/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : gnf

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 09/03/2018 09:23:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for attachment
-- ----------------------------
DROP TABLE IF EXISTS `attachment`;
CREATE TABLE `attachment` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `file_ext` varchar(255) DEFAULT NULL,
  `ftp_path` varchar(255) DEFAULT NULL,
  `ftp_real_path` varchar(255) DEFAULT NULL,
  `media_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `original_name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `real_path` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `size` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `type` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of attachment
-- ----------------------------
BEGIN;
INSERT INTO `attachment` VALUES ('1', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/10/ppt1.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt1.JPG', NULL, 'ppt1.JPG', 'ppt1.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('10', '2018-01-08 22:37:10', '.jpg', '/gnftest/img/201801/10/ppt10.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt10.JPG', NULL, 'ppt10.JPG', 'ppt10.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('11', '2018-01-08 22:37:11', '.jpg', '/gnftest/img/201801/10/ppt11.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt11.JPG', NULL, 'ppt11.JPG', 'ppt11.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('12', '2018-01-08 22:37:12', '.jpg', '/gnftest/img/201801/10/ppt12.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt12.JPG', NULL, 'ppt12.JPG', 'ppt12.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('13', '2018-01-08 22:37:13', '.jpg', '/gnftest/img/201801/10/ppt13.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt13.JPG', NULL, 'ppt13.JPG', 'ppt13.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('14', '2018-01-08 22:37:14', '.jpg', '/gnftest/img/201801/10/ppt14.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt14.JPG', NULL, 'ppt14.JPG', 'ppt14.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('15', '2018-01-08 22:37:15', '.jpg', '/gnftest/img/201801/10/ppt15.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt15.JPG', NULL, 'ppt15.JPG', 'ppt15.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('16', '2018-01-08 22:37:16', '.jpg', '/gnftest/img/201801/10/ppt16.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt16.JPG', NULL, 'ppt16.JPG', 'ppt16.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('17', '2018-01-08 22:37:17', '.jpg', '/gnftest/img/201801/10/ppt17.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt17.JPG', NULL, 'ppt17.JPG', 'ppt17.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('18', '2018-01-08 22:37:18', '.jpg', '/gnftest/img/201801/10/ppt18.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt18.JPG', NULL, 'ppt18.JPG', 'ppt18.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('180996d4-6f46-4b24-b3d9-b4e302f364aa', '2018-03-07 11:55:40', '.jpg', '', '', NULL, '2018030711554037946.jpg', 'image.jpg', '/uploadFiles/web/20180307/2018030711554037946.jpg', '/opt/apps/tomcat-mmw-a/webapps/gnftest/uploadFiles/web/20180307/2018030711554037946.jpg', '', 690881, 0, 1, '2018-03-07 11:55:40');
INSERT INTO `attachment` VALUES ('19', '2018-01-08 22:37:19', '.jpg', '/gnftest/img/201801/10/ppt19.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt19.JPG', NULL, 'ppt19.JPG', 'ppt19.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('1c157339-9fce-4741-8cd4-5dac8fa68bb7', '2018-03-07 17:51:02', '.ppt', '', '', NULL, '2018030717510285042.ppt', 'ICP备案流程演示.ppt', '/uploadFiles/web/20180307/2018030717510285042.ppt', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180307/2018030717510285042.ppt', '', 2119168, 0, 4, '2018-03-07 17:51:02');
INSERT INTO `attachment` VALUES ('1f5430f2-ab3c-40e5-ba76-608fcbb28ca4', '2018-02-28 15:18:21', '.png', '', '', NULL, '2018022815182193916.png', 'qrcode_8cm.png', '/uploadFiles/web/20180228/2018022815182193916.png', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180228/2018022815182193916.png', '', 1560, 0, 1, '2018-02-28 15:18:21');
INSERT INTO `attachment` VALUES ('1fe5b6aa-a195-49cb-9a06-860dda7bc6c8', '2018-02-27 18:22:05', '.mp4', '', '', NULL, '2018022718220546352.mp4', '2018010918473497319.mp4', '/uploadFiles/web/20180227/2018022718220546352.mp4', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180227/2018022718220546352.mp4', '', 18789780, 0, 2, '2018-02-27 18:22:06');
INSERT INTO `attachment` VALUES ('2', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/10/ppt2.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt2.JPG', NULL, 'ppt2.JPG', 'ppt2.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('20', '2018-01-08 22:37:20', '.jpg', '/gnftest/img/201801/10/ppt20.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt20.JPG', NULL, 'ppt20.JPG', 'ppt20.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('20598b75-2e00-419c-9b85-95cfc535aa0a', '2018-02-28 15:10:16', '.png', '', '', NULL, '2018022815101672526.png', '1515406829.png', '/uploadFiles/web/20180228/2018022815101672526.png', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180228/2018022815101672526.png', '', 1518, 0, 1, '2018-02-28 15:10:16');
INSERT INTO `attachment` VALUES ('21', '2018-01-08 22:37:21', '.jpg', '/gnftest/img/201801/10/ppt21.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt21.JPG', NULL, 'ppt21.JPG', 'ppt21.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('210ed2c0-316e-4fc3-9a1d-ce1a347ebe69', '2018-02-28 09:38:25', '.jpg', '', '', NULL, '2018022809382570748.jpg', 'TB2SG59j9fD8KJjSszhXXbIJFXa_!!779662272.jpg', '/uploadFiles/web/20180228/2018022809382570748.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180228/2018022809382570748.jpg', '', 114646, 0, 1, '2018-02-28 09:38:25');
INSERT INTO `attachment` VALUES ('22', '2018-01-08 22:37:22', '.jpg', '/gnftest/img/201801/10/ppt22.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt22.JPG', NULL, 'ppt22.JPG', 'ppt22.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('23', '2018-01-08 22:37:23', '.jpg', '/gnftest/img/201801/10/ppt23.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt23.JPG', NULL, 'ppt23.JPG', 'ppt23.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('24', '2018-01-08 22:37:24', '.jpg', '/gnftest/img/201801/10/ppt24.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt24.JPG', NULL, 'ppt24.JPG', 'ppt24.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('25', '2018-01-08 22:37:25', '.jpg', '/gnftest/img/201801/10/ppt25.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt25.JPG', NULL, 'ppt25.JPG', 'ppt25.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('26', '2018-01-08 22:37:26', '.jpg', '/gnftest/img/201801/10/ppt26.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt26.JPG', NULL, 'ppt26.JPG', 'ppt26.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('27', '2018-01-08 22:37:27', '.jpg', '/gnftest/img/201801/10/ppt27.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt27.JPG', NULL, 'ppt27.JPG', 'ppt27.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('28', '2018-01-08 22:37:28', '.jpg', '/gnftest/img/201801/10/ppt28.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt28.JPG', NULL, 'ppt28.JPG', 'ppt28.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('29', '2018-01-08 22:37:29', '.jpg', '/gnftest/img/201801/10/ppt29.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt29.JPG', NULL, 'ppt29.JPG', 'ppt29.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('3', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/10/ppt3.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt3.JPG', NULL, 'ppt3.JPG', 'ppt3.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('30', '2018-01-08 22:37:30', '.jpg', '/gnftest/img/201801/10/ppt29.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt30.JPG', NULL, 'ppt30.JPG', 'ppt30.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('31', '2018-01-08 22:37:31', '.jpg', '/gnftest/img/201801/10/ppt31.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt31.JPG', NULL, 'ppt31.JPG', 'ppt31.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('32', '2018-01-08 22:37:32', '.jpg', '/gnftest/img/201801/10/ppt32.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt32.JPG', NULL, 'ppt32.JPG', 'ppt32.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('33', '2018-01-08 22:37:33', '.jpg', '/gnftest/img/201801/10/ppt33.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt33.JPG', NULL, 'ppt33.JPG', 'ppt33.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('34', '2018-01-08 22:37:34', '.jpg', '/gnftest/img/201801/10/ppt34.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt34.JPG', NULL, 'ppt34.JPG', 'ppt34.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('35', '2018-01-08 22:37:35', '.jpg', '/gnftest/img/201801/10/ppt35.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt35.JPG', NULL, 'ppt35.JPG', 'ppt35.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('36', '2018-01-08 22:37:36', '.jpg', '/gnftest/img/201801/10/ppt36.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt36.JPG', NULL, 'ppt36.JPG', 'ppt36.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('37', '2018-01-08 22:37:37', '.jpg', '/gnftest/img/201801/10/ppt37.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt37.JPG', NULL, 'ppt37.JPG', 'ppt37.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('38', '2018-01-08 22:37:38', '.jpg', '/gnftest/img/201801/10/ppt38.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt38.JPG', NULL, 'ppt38.JPG', 'ppt38.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('38cc3005-d463-408e-b716-f2cae342bbf8', '2018-02-28 10:27:45', '.jpg', '', '', NULL, '2018022810274580718.jpg', 'TB2SG59j9fD8KJjSszhXXbIJFXa_!!779662272.jpg', '/uploadFiles/web/20180228/2018022810274580718.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180228/2018022810274580718.jpg', '', 114646, 0, 1, '2018-02-28 10:27:45');
INSERT INTO `attachment` VALUES ('3a745738-1a79-49e8-ab7e-da03dd91396c', '2018-02-27 11:42:33', '.png', '/gnftest/img/201802/27/2018022711423375196.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711423375196.png', NULL, '2018022711423375196.png', '返现券.png', '/uploadFiles/web/20180227/2018022711423375196.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711423375196.png', '', 6395, 0, 1, '2018-02-27 11:42:35');
INSERT INTO `attachment` VALUES ('3f8f0a23-eccf-47a2-8d63-d952a77d171b', '2018-02-28 09:39:42', '.jpg', '', '', NULL, '2018022809394266503.jpg', 'TB2UumFcFXXXXaHXXXXXXXXXXXX_!!2321977079 (1).jpg', '/uploadFiles/web/20180228/2018022809394266503.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180228/2018022809394266503.jpg', '', 279487, 0, 1, '2018-02-28 09:39:42');
INSERT INTO `attachment` VALUES ('4', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/10/ppt4.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt4.JPG', NULL, 'ppt4.JPG', 'ppt4.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('4bf952e1-0227-4081-8d43-8055d8d9e649', '2018-02-27 15:56:31', '.png', '/gnftest/img/201802/27/2018022715563179712.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022715563179712.png', NULL, '2018022715563179712.png', 'qrcode_8cm.png', '/uploadFiles/web/20180227/2018022715563179712.png', '/opt/apps/tomcat-mmw-a/webapps/gnftest/uploadFiles/web/20180227/2018022715563179712.png', '', 1560, 0, 1, '2018-02-27 15:56:32');
INSERT INTO `attachment` VALUES ('5', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/10/ppt5.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt5.JPG', NULL, 'ppt5.JPG', 'ppt5.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('5538ec98-1bc3-46ef-93e1-c571a12b561f', '2018-02-26 17:06:16', '.jpg', '/gnftest/img/201802/26/2018022617061659855.jpg', 'http://res.mamawen.org/omv/gnftest/img/201802/26/2018022617061659855.jpg', NULL, '2018022617061659855.jpg', 'TB2Xkexk_nI8KJjSszgXXc8ApXa_!!928333787 (2).jpg', '/uploadFiles/web/20180226/2018022617061659855.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180226/2018022617061659855.jpg', '', 178826, 0, 1, '2018-02-26 17:06:17');
INSERT INTO `attachment` VALUES ('597ccf27-41a6-482a-b4c1-0c7fd6946a7c', '2018-02-27 11:53:43', '.png', '/gnftest/img/201802/27/2018022711534379508.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711534379508.png', NULL, '2018022711534379508.png', '返现券.png', '/uploadFiles/web/20180227/2018022711534379508.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711534379508.png', '', 6395, 0, 1, '2018-02-27 11:53:44');
INSERT INTO `attachment` VALUES ('5fcecb20-6aeb-480d-b8c8-77c7119a68e7', '2018-02-27 16:34:14', '.png', '/gnftest/img/201802/27/2018022716341426352.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022716341426352.png', NULL, '2018022716341426352.png', '返现券.png', '/uploadFiles/web/20180227/2018022716341426352.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022716341426352.png', '', 6395, 0, 1, '2018-02-27 16:34:15');
INSERT INTO `attachment` VALUES ('6', '2018-01-08 22:36:36', '.jpg', '/gnftest/img/201801/10/ppt6.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt6.JPG', NULL, 'ppt6.JPG', 'ppt6.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('672602a0-3147-41f4-9d8e-1e6f8909da9a', '2018-01-08 22:36:35', '.jpg', '/gnftest/img/201801/08/2018010822363547118.jpg', 'http://res.mamawen.org/omv/gnftest/img/201801/08/2018010822363547118.jpg', NULL, '2018010822363547118.jpg', 'banner.jpg', '/uploadFiles/web/20180108/2018010822363547118.jpg', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180108/2018010822363547118.jpg', '', 69664, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('7', '2018-01-08 22:36:37', '.jpg', '/gnftest/img/201801/10/ppt7.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt7.JPG', NULL, 'ppt7.JPG', 'ppt7.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('7daadbfc-4314-46ce-985e-796c3c55afc8', '2018-02-27 11:37:07', '.png', '/gnftest/img/201802/27/2018022711370776492.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711370776492.png', NULL, '2018022711370776492.png', '返现券.png', '/uploadFiles/web/20180227/2018022711370776492.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711370776492.png', '', 6395, 0, 1, '2018-02-27 11:37:08');
INSERT INTO `attachment` VALUES ('8', '2018-01-08 22:36:38', '.jpg', '/gnftest/img/201801/10/ppt8.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt8.JPG', NULL, 'ppt8.JPG', 'ppt8.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('9', '2018-01-08 22:36:39', '.jpg', '/gnftest/img/201801/10/ppt9.JPG', 'http://res.mamawen.org/omv/gnftest/img/201801/10/ppt9.JPG', NULL, 'ppt9.JPG', 'ppt9.JPG', '', '', '', 0, 0, 1, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('9765c8f4-e196-4036-aea4-6e194289046d', '2018-02-28 10:18:27', '.jpg', '', '', NULL, '2018022810182712784.jpg', 'TB2SG59j9fD8KJjSszhXXbIJFXa_!!779662272.jpg', '/uploadFiles/web/20180228/2018022810182712784.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180228/2018022810182712784.jpg', '', 114646, 0, 1, '2018-02-28 10:18:27');
INSERT INTO `attachment` VALUES ('a934fc85-1b67-48aa-b5fd-bcefb7165082', '2018-02-27 11:18:25', '.png', '/gnftest/img/201802/27/2018022711182576571.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711182576571.png', NULL, '2018022711182576571.png', '首页-返现券.png', '/uploadFiles/web/20180227/2018022711182576571.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711182576571.png', '', 276762, 0, 1, '2018-02-27 11:18:27');
INSERT INTO `attachment` VALUES ('ac18a4ff-34c2-4ddd-9406-506e78d442eb', '2018-02-27 11:21:43', '.png', '/gnftest/img/201802/27/2018022711214383167.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711214383167.png', NULL, '2018022711214383167.png', '返现券.png', '/uploadFiles/web/20180227/2018022711214383167.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711214383167.png', '', 6395, 0, 1, '2018-02-27 11:21:44');
INSERT INTO `attachment` VALUES ('aeb87ec3-2314-421c-803e-21880df1be59', '2018-02-27 16:30:01', '.png', '', '', NULL, '2018022716300152601.png', '微信截图_20171113124456.png', '/uploadFiles/web/20180227/2018022716300152601.png', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180227/2018022716300152601.png', '', 19807, 0, 1, '2018-02-27 16:30:01');
INSERT INTO `attachment` VALUES ('b3f3e075-444f-45a5-aa4c-5245c8d1e03b', '2018-02-27 11:21:07', '.png', '/gnftest/img/201802/27/2018022711210733498.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711210733498.png', NULL, '2018022711210733498.png', '领取返现券.png', '/uploadFiles/web/20180227/2018022711210733498.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711210733498.png', '', 172396, 0, 1, '2018-02-27 11:21:08');
INSERT INTO `attachment` VALUES ('bae9692d-06f1-4f05-93bd-5118d68c649c', '2018-02-28 15:01:47', '.mp4', '', '', NULL, '2018022815014754441.mp4', 'bd46488a46517f6d00211682cf1e0f64 (1).mp4', '/uploadFiles/web/20180228/2018022815014754441.mp4', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180228/2018022815014754441.mp4', '', 3129371, 0, 2, '2018-02-28 15:01:48');
INSERT INTO `attachment` VALUES ('c7cfccf0-1655-44b8-8666-12f5281082e2', '2018-02-28 15:11:52', '.png', '', '', NULL, '2018022815115217317.png', '121.png', '/uploadFiles/web/20180228/2018022815115217317.png', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180228/2018022815115217317.png', '', 39985, 0, 1, '2018-02-28 15:11:52');
INSERT INTO `attachment` VALUES ('d462c0fb-c06d-4a4d-a0bb-269c8b03743a', '2018-02-26 17:06:11', '.jpg', '/gnftest/img/201802/26/2018022617061111933.jpg', 'http://res.mamawen.org/omv/gnftest/img/201802/26/2018022617061111933.jpg', NULL, '2018022617061111933.jpg', 'TB2S1RMjWagSKJjy0FbXXa.mVXa_!!71216896.jpg', '/uploadFiles/web/20180226/2018022617061111933.jpg', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180226/2018022617061111933.jpg', '', 144963, 0, 1, '2018-02-26 17:06:13');
INSERT INTO `attachment` VALUES ('eab7bc51-d8e3-485f-8c88-077343f2bbbc', '2018-02-27 18:22:45', '.png', '', '', NULL, '2018022718224546052.png', 'qrcode_8cm.png', '/uploadFiles/web/20180227/2018022718224546052.png', 'E:/java/apache-tomcat-7.0.56/webapps/ROOT/uploadFiles/web/20180227/2018022718224546052.png', '', 1560, 0, 1, '2018-02-27 18:22:45');
INSERT INTO `attachment` VALUES ('fea54c4e-c20e-4bc1-b2ee-0b256c9b2053', '2018-02-27 11:35:30', '.png', '/gnftest/img/201802/27/2018022711353014799.png', 'http://res.mamawen.org/omv/gnftest/img/201802/27/2018022711353014799.png', NULL, '2018022711353014799.png', '返现券.png', '/uploadFiles/web/20180227/2018022711353014799.png', '/Users/zhurusen/Workspaces/apache-tomcat-8.5.23/webapps/gnf/uploadFiles/web/20180227/2018022711353014799.png', '', 6395, 0, 1, '2018-02-27 11:35:32');
INSERT INTO `attachment` VALUES ('pdf_1', '2018-01-08 22:37:38', '.mp4', '/gnftest/other/201801/10/20180110szjk-1.pdf', 'http://res.mamawen.org/omv/gnftest/other/201801/10/20180110szjk-1.pdf', NULL, '20180110szjk-1.pdf', '20180110szjk-1.pdf', '', '', '', 0, 0, 7, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('video_1', '2018-01-08 22:37:38', '.mp4', '/static/wx/images/20180110perter1.mp4', 'http://res.mamawen.org/omv/gnftest/vod/201801/10/20180110perter1.mp4', NULL, '0180110perter.mp4', '0180110perter.mp4', '', '', '', 0, 0, 2, '2018-01-08 22:36:36');
INSERT INTO `attachment` VALUES ('video_2', '2018-01-12 14:16:55', '.mp4', '/gnftest/vod/201801/12/20180112perterppt.mp4', 'http://res.mamawen.org/omv/gnftest/vod/201801/12/20180112perterppt.mp4', NULL, '20180112perterppt.mp4', '20180112perterppt.mp4', NULL, NULL, NULL, 0, 0, 2, '2018-01-12 14:20:50');
INSERT INTO `attachment` VALUES ('video_3', '2018-01-12 14:16:55', '.mp4', '/gnftest/vod/201801/12/20180112case-1.mp4', 'http://res.mamawen.org/omv/gnftest/vod/201801/12/20180112case-1.mp4', NULL, '20180112case-1.mp4', '20180112case-1.mp4', NULL, NULL, NULL, 0, 0, 2, '2018-01-12 14:20:50');
INSERT INTO `attachment` VALUES ('video_4', '2018-01-12 14:16:55', '.mp4', '/gnftest/vod/201801/12/20180112case-2.mp4', 'http://res.mamawen.org/omv/gnftest/vod/201801/12/20180112case-2.mp4', NULL, '20180112case-2.mp4', '20180112case-2.mp4', NULL, NULL, NULL, 0, 0, 2, '2018-01-12 14:20:50');
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` varchar(255) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `is_show` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `attachment_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKACC57F2C1D6A0B84` (`attachment_id`) USING BTREE,
  CONSTRAINT `FKACC57F2C1D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` VALUES ('1', NULL, '2018-01-07 18:06:28', 0, 'banner信息', 1, 0, '2018-01-07 18:08:23', '', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `banner` VALUES ('2', NULL, '2018-01-07 18:09:03', 0, 'banner信息', 2, 0, '2018-01-07 18:09:15', NULL, '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `banner` VALUES ('3', NULL, '2018-01-07 18:12:57', 0, 'banner信息', 3, 0, '2018-01-08 22:36:39', '', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `banner` VALUES ('4af36b59-f814-4404-8586-d174659fe472', NULL, '2018-01-08 21:59:20', 0, 'banner信息', 4, 0, '2018-01-08 22:34:46', '', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `banner` VALUES ('a68e656b-027e-4989-9781-b2c9187abb24', NULL, '2018-02-27 15:56:52', 1, '1', 2, 0, '2018-02-27 15:56:52', '3', '4bf952e1-0227-4081-8d43-8055d8d9e649');
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` varchar(255) NOT NULL,
  `att_type` bigint(20) DEFAULT NULL,
  `collection_number` int(11) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `discuss_number` int(11) DEFAULT NULL,
  `is_add_integral` bigint(20) DEFAULT NULL,
  `like_number` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read_number` int(11) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `video_att` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `video_att_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK38A5EE5F146ECB25` (`user_id`) USING BTREE,
  KEY `FK38A5EE5F58CB898A` (`video_att_id`) USING BTREE,
  CONSTRAINT `FK38A5EE5F146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK38A5EE5F58CB898A` FOREIGN KEY (`video_att_id`) REFERENCES `attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES ('1', 2, 2, '数据1', '2018-02-23 09:05:16', 1, 10, 20, '视频数据', 0, 0, 0, '2018-02-23 09:06:21', NULL, '0be1af05-39c6-424a-8149-32f3d4dd6879', NULL);
COMMIT;

-- ----------------------------
-- Table structure for comment_img_attachment
-- ----------------------------
DROP TABLE IF EXISTS `comment_img_attachment`;
CREATE TABLE `comment_img_attachment` (
  `comment_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK889EC4FF1D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK889EC4FFF3A5400F` (`comment_id`) USING BTREE,
  CONSTRAINT `FK889EC4FF1D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK889EC4FFF3A5400F` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for communion
-- ----------------------------
DROP TABLE IF EXISTS `communion`;
CREATE TABLE `communion` (
  `id` varchar(255) NOT NULL,
  `att_type` bigint(20) DEFAULT NULL,
  `collection_number` int(11) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `discuss_number` int(11) DEFAULT NULL,
  `is_add_integral` bigint(20) DEFAULT NULL,
  `like_number` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read_number` int(11) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `video_att` tinyblob,
  `user_id` varchar(255) DEFAULT NULL,
  `video_att_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKA7C52F43146ECB25` (`user_id`) USING BTREE,
  KEY `FKA7C52F4358CB898A` (`video_att_id`) USING BTREE,
  CONSTRAINT `FKA7C52F43146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKA7C52F4358CB898A` FOREIGN KEY (`video_att_id`) REFERENCES `attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of communion
-- ----------------------------
BEGIN;
INSERT INTO `communion` VALUES ('1', 2, 1, '11111', '2018-02-26 15:44:48', 112, 11, 1, '名称', 12, 1, 0, '2018-02-26 15:45:05', NULL, '0be1af05-39c6-424a-8149-32f3d4dd6879', '13');
INSERT INTO `communion` VALUES ('33a56dd7-6f51-47a8-8d65-ceabb933f9d3', 1, 0, 'ssssssss', '2018-02-27 11:18:30', 0, 0, 0, 'ssssssss', 0, NULL, 0, '2018-02-27 11:18:30', NULL, 'manager', NULL);
INSERT INTO `communion` VALUES ('68e62c81-c3bd-409b-80ed-f2b0680de402', 1, 0, 'sssadasd', '2018-02-27 11:21:10', 0, 0, 0, 'sssadasd', 0, NULL, 0, '2018-02-27 11:21:10', NULL, 'manager', NULL);
INSERT INTO `communion` VALUES ('6cd57448-32f7-46c7-b4fc-850e8a3df7fb', 1, 0, 'sssssdasd', '2018-02-27 11:21:48', 0, 0, 0, 'sssssdasd', 0, NULL, 0, '2018-02-27 11:21:48', NULL, 'manager', NULL);
INSERT INTO `communion` VALUES ('c30b5729-0f88-4bec-b380-9db37c68c8c0', 1, 0, '1212', '2018-02-28 15:10:17', 0, 0, 0, '1212', 0, NULL, 0, '2018-02-28 15:10:17', NULL, 'manager', NULL);
COMMIT;

-- ----------------------------
-- Table structure for communion_img_attachment
-- ----------------------------
DROP TABLE IF EXISTS `communion_img_attachment`;
CREATE TABLE `communion_img_attachment` (
  `communion_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK75011F9B1D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK75011F9BC680C4F` (`communion_id`) USING BTREE,
  CONSTRAINT `FK75011F9B1D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK75011F9BC680C4F` FOREIGN KEY (`communion_id`) REFERENCES `communion` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of communion_img_attachment
-- ----------------------------
BEGIN;
INSERT INTO `communion_img_attachment` VALUES ('33a56dd7-6f51-47a8-8d65-ceabb933f9d3', 'a934fc85-1b67-48aa-b5fd-bcefb7165082');
INSERT INTO `communion_img_attachment` VALUES ('68e62c81-c3bd-409b-80ed-f2b0680de402', 'b3f3e075-444f-45a5-aa4c-5245c8d1e03b');
INSERT INTO `communion_img_attachment` VALUES ('6cd57448-32f7-46c7-b4fc-850e8a3df7fb', 'ac18a4ff-34c2-4ddd-9406-506e78d442eb');
INSERT INTO `communion_img_attachment` VALUES ('c30b5729-0f88-4bec-b380-9db37c68c8c0', '20598b75-2e00-419c-9b85-95cfc535aa0a');
COMMIT;

-- ----------------------------
-- Table structure for discuss
-- ----------------------------
DROP TABLE IF EXISTS `discuss`;
CREATE TABLE `discuss` (
  `id` varchar(255) NOT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `is_good` bigint(20) DEFAULT NULL,
  `isshow` varchar(255) DEFAULT NULL,
  `likenumber` int(11) DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `parentnode_id` varchar(255) DEFAULT NULL,
  `rootparentnode_id` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `parent_id` varchar(255) DEFAULT NULL,
  `rootparent_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `component_id` varchar(255) DEFAULT NULL,
  `is_optimu` bigint(20) DEFAULT NULL COMMENT '是否为最佳评论（0 是 1 否）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK639F53E020D64F96` (`rootparent_id`) USING BTREE,
  KEY `FK639F53E0146ECB25` (`user_id`) USING BTREE,
  KEY `FK639F53E05405F238` (`parent_id`) USING BTREE,
  CONSTRAINT `FK639F53E0146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK639F53E020D64F96` FOREIGN KEY (`rootparent_id`) REFERENCES `discuss` (`id`),
  CONSTRAINT `FK639F53E05405F238` FOREIGN KEY (`parent_id`) REFERENCES `discuss` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of discuss
-- ----------------------------
BEGIN;
INSERT INTO `discuss` VALUES ('00d0b81b-352a-4c5e-b10e-c6899be26e5f', '大萨达大萨达撒多大萨达撒', '2018-02-28 10:22:04', NULL, '0', 0, 'interlocution', 'e5565093-899d-4262-8640-535bc07ae490', NULL, NULL, '0', 0, '2018-02-28 10:22:04', NULL, NULL, 'manager', 'comment', 0);
INSERT INTO `discuss` VALUES ('029ff85d-fbfa-43f0-a9b5-d3f1d54fb97f', '洒水撒所所搜索四十三', '2018-02-26 15:49:30', NULL, '0', 1, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:30', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('051eb778-bd0b-4fe9-b74c-7c4d5b174dc8', '地方过分', '2018-01-11 19:25:55', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 19:25:55', NULL, NULL, '384ea627-d64b-4f57-89d5-c8fa083ff43c', 'comment', NULL);
INSERT INTO `discuss` VALUES ('07fce550-507e-46c5-98cb-e9675d1c2ed6', 'assssss', '2018-01-06 20:55:11', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-06 20:55:11', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('0a0b817f-a052-4ec5-96ba-3328d3e1ff75', '1', '2018-02-26 15:54:23', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:23', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('0ae924ec-a0a3-424a-af77-33595743f7d0', 'sssssssdadsa', '2018-02-28 10:28:01', NULL, '0', 1, 'interlocution', '15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', NULL, NULL, '0', 0, '2018-02-28 10:28:01', NULL, NULL, 'manager', 'comment', 0);
INSERT INTO `discuss` VALUES ('0ca0cb7a-582b-41d2-857f-d9939cb93d3c', '2', '2018-02-26 16:08:55', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 16:08:55', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('0dd55420-e4f0-4c78-8c14-b1f47e8140ac', '测试', '2018-01-11 19:26:25', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-11 19:26:25', NULL, NULL, '384ea627-d64b-4f57-89d5-c8fa083ff43c', 'comment', NULL);
INSERT INTO `discuss` VALUES ('0e77bf06-1695-4b57-a3a4-cd5541dcb469', '3', '2018-02-26 15:54:18', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:18', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('0f5697e6-8a87-4b5c-be1c-5f627ade043d', 'dasdasda', '2018-02-28 10:28:28', NULL, '0', 0, 'interlocution', 'c9fbb3b8-d914-4c79-baf9-30d80099b514', NULL, NULL, '0', 0, '2018-02-28 10:28:28', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('106a9d62-ca4d-4141-9276-5cf10a4e6665', '洒水撒所所搜索四十三', '2018-02-26 15:49:33', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:33', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('12848e6d-2400-42b7-a437-f44185c54442', 'qqqqqsss', '2018-01-10 16:37:08', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-10 16:37:08', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('16e32aee-fcb7-4526-ab88-8d3592ce9bff', '洒水撒所所', '2018-02-26 15:48:53', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:48:53', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('172fd641-5737-49f3-a6db-601263e72e2c', '4', '2018-02-26 15:54:20', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:20', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('1c275c57-11cd-4207-8a28-e32ec44b8f48', '5', '2018-02-26 15:53:48', NULL, '0', 1, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:53:48', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('1f54aa56-b3dd-4a6f-bff2-0aa6abe4f625', '手上的撒阿斯顿撒多', '2018-02-27 20:35:20', NULL, '0', 0, 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', NULL, NULL, '0', 0, '2018-02-27 20:35:20', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('24d0a045-6c2b-44e5-a334-f4eaa93a07d7', '2131a\'s\'d恶趣味', '2018-01-08 09:40:39', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 09:40:39', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('2ba7b72c-44e2-45b8-8acf-abc188f2fc34', '您好', '2018-01-11 17:56:47', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 17:56:47', NULL, NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 'comment', NULL);
INSERT INTO `discuss` VALUES ('2bae6d52-f15e-4690-8c45-591493075c1d', '肯定', '2018-03-07 11:54:22', NULL, '0', 0, 'interlocution', '1', NULL, NULL, '0', 0, '2018-03-07 11:54:22', NULL, NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 'comment', 1);
INSERT INTO `discuss` VALUES ('2c49658b-534a-4b8e-890d-fc204f4650eb', 'qqqqq', '2018-01-10 16:36:56', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-10 16:36:56', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('2ec0f72d-3289-44ef-a107-dc39add82c00', 'sssss', '2018-02-28 10:27:57', NULL, '0', 0, 'interlocution', '15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', NULL, NULL, '0', 0, '2018-02-28 10:27:57', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('2fe9af84-d89a-4418-a695-ef3abc54b032', '洒水撒所所', '2018-02-27 16:46:27', NULL, '0', 1, 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', NULL, NULL, '0', 0, '2018-02-27 16:46:27', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('358f20fd-5227-4eae-97f8-37287b809409', '好的', '2018-01-10 18:47:52', NULL, '0', 0, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-10 18:47:52', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('35b4024a-85d3-45a6-80d4-f88dcc3f5fa4', '哦哦哦', '2018-01-11 18:53:40', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 18:53:40', NULL, NULL, '0e568a49-426a-4c0f-8730-2f3d62828c11', 'comment', NULL);
INSERT INTO `discuss` VALUES ('4580fcc6-70d6-4ab6-97e0-51b4be44c448', 'dddd', '2018-01-07 20:25:29', NULL, '0', 0, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-07 20:25:29', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('4ad5c730-a892-4fb7-a322-5545b186fad1', '6', '2018-02-27 16:59:18', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-27 16:59:18', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('4ddc6a14-6c64-4c30-8e9c-acb3625dd9df', '哦哦哦金科路', '2018-01-11 18:53:49', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 18:53:49', NULL, NULL, '0e568a49-426a-4c0f-8730-2f3d62828c11', 'comment', NULL);
INSERT INTO `discuss` VALUES ('4e193805-dade-4c26-a6c4-83826939a578', 'sssssss', '2018-02-28 15:10:10', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-28 15:10:10', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('52dc8df7-116a-4fbd-ae23-0abfbea20dd0', '三生三世', '2018-02-27 16:30:54', NULL, '0', 1, 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', NULL, NULL, '0', 0, '2018-02-27 16:30:54', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('548278d4-64b5-492c-9be5-bdc389d0ea88', '洒水撒所所搜索四十三', '2018-02-26 15:49:31', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:31', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('5667d9ff-5729-4b60-a415-d0e19cbb2613', '7', '2018-02-26 15:54:22', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:22', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('589e59d5-cc08-49b4-8c6a-124bc1e019dd', '8', '2018-02-26 16:08:46', NULL, '0', 1, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 16:08:46', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('5a5508ca-fc51-40c8-aad1-83b772ab5cd9', '9', '2018-02-26 16:08:50', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 16:08:50', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('5d0c95f3-2ef3-49d7-89c4-2c90aba8b82c', 'ssssss', '2018-02-28 10:10:02', NULL, '0', 0, 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', NULL, NULL, '0', 0, '2018-02-28 10:10:02', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('6f2ca7a7-d55c-4481-be64-101d55ffc6d2', 'aaaa', '2018-02-28 15:18:28', NULL, '0', 0, 'interlocution', '9249721b-8861-4e4e-a196-723062f67350', NULL, NULL, '0', 0, '2018-02-28 15:18:28', NULL, NULL, 'manager', 'comment', 0);
INSERT INTO `discuss` VALUES ('7485ecc2-c2e7-4014-941c-dd6dd4bf6e72', '你好', '2018-01-10 15:31:19', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-10 15:31:19', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('74e7ff8e-3c6b-4eda-b532-012b412e73a8', 'wwwwwww', '2018-01-06 20:50:12', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-06 20:50:12', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('7b7adc34-31ba-4e76-af11-6325aea7bede', '洒水撒所所搜索四十三', '2018-02-26 15:49:34', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:34', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('7efcea42-7332-4842-bd0b-683a19519979', 'wqeqweqwe', '2018-01-08 16:09:33', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 16:09:33', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('88fdd61e-bcc6-45cc-8758-8c68c2e0b3d2', '1111', '2018-02-28 10:11:52', NULL, '0', 0, 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', NULL, NULL, '0', 0, '2018-02-28 10:11:52', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('8cc09e53-1e02-44c9-a49c-d061202c3648', '123123123', '2018-01-08 09:38:11', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 09:38:11', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('8cf20048-a0cd-498a-81cc-f8b95340f8a2', '洒水撒所所搜索四十三sss', '2018-02-26 15:54:08', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:54:08', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('92d00e37-820a-4c06-beeb-5c2b32f86006', '洒水撒所所搜索', '2018-02-26 15:49:24', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:24', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('9aa9a553-7cf5-4428-98cd-8229a787ed8a', '123', '2018-01-12 09:37:00', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-12 09:37:00', NULL, NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 'comment', NULL);
INSERT INTO `discuss` VALUES ('a1f7ae00-abe1-44c2-a70b-e1e9117307b0', 'dddd', '2018-01-10 17:53:59', NULL, '0', 0, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-10 17:53:59', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('a2f23c94-8a69-463d-915f-6fe54b13e2be', '对对对', '2018-01-11 18:45:35', NULL, '0', 2, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-11 18:45:35', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('a46bce92-795e-4a8d-a0e3-f4c7b04392ba', '1231344556666', '2018-01-08 16:12:38', NULL, '0', 2, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 16:12:38', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('a7eb5b37-8f80-4a80-9ec4-cc5c1d45d311', '哈哈', '2018-01-11 17:57:33', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 17:57:33', NULL, NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 'comment', NULL);
INSERT INTO `discuss` VALUES ('b00c64c2-67b3-4a14-9fa5-c4ce8eab1aad', '洒水撒所所搜索四十三', '2018-02-26 15:49:28', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:28', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('b574562b-7f36-4495-b7dc-67c613e4e615', '洒水撒所所搜索四十三', '2018-02-26 15:49:35', NULL, '0', 0, 'communion', '1', NULL, NULL, '0', 0, '2018-02-26 15:49:35', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('ba855139-8b49-4811-9d25-d260a9b60e73', '10', '2018-02-26 15:54:16', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:16', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('bc21a96b-2197-4c2f-a08f-e1b446016b3c', 'dcccc', '2018-02-28 15:18:47', NULL, '0', 0, 'interlocution', '7d11fea4-e628-46be-bcb2-776a3c228778', NULL, NULL, '0', 0, '2018-02-28 15:18:47', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('c03e9c8d-e493-44bc-97d4-cdc1ef2be474', '11', '2018-02-26 16:18:37', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 16:18:37', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('c3b89277-84b6-4d3c-a33e-c9431f993cb1', 'dddd', '2018-01-07 20:24:40', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-07 20:24:40', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('c44f842e-ae6e-48a2-a1c2-df11306266de', 'ssss', '2018-02-28 10:04:20', NULL, '0', 0, 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', NULL, NULL, '0', 0, '2018-02-28 10:04:20', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('c83b9a5f-4eaa-4b4a-b14c-b7d53d258818', '12', '2018-02-27 16:59:22', NULL, '0', 1, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-27 16:59:22', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('cda6bed8-1df9-4604-af5e-93d33ed7c0e2', '哦哦哦', '2018-01-11 18:53:04', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 18:53:04', NULL, NULL, '0e568a49-426a-4c0f-8730-2f3d62828c11', 'comment', NULL);
INSERT INTO `discuss` VALUES ('d3ea2bf9-c470-4312-8def-a0b1d0fca290', '12313', '2018-01-08 16:12:30', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 16:12:30', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('d7fd80d2-31c9-483d-99b1-b27d5f209053', 'dddd', '2018-01-07 20:25:36', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-07 20:25:36', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('d83eb5c3-c9f6-45ed-8d8b-094b03cfba3b', '123', '2018-01-11 17:59:35', NULL, '0', 0, 'explanation', '2', NULL, NULL, '0', 0, '2018-01-11 17:59:35', NULL, NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 'comment', NULL);
INSERT INTO `discuss` VALUES ('e1a73f5f-a985-4fcf-ae28-5f622dfdded0', '13', '2018-02-26 15:53:51', NULL, '0', 0, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:53:51', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('e6ea4cdb-603e-4c56-b258-17061231b2c6', '实打实大所多撒大所', '2018-02-27 20:34:43', NULL, '0', 0, 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', NULL, NULL, '0', 0, '2018-02-27 20:34:43', NULL, NULL, 'manager', 'comment', 0);
INSERT INTO `discuss` VALUES ('e892140c-d5cd-405a-a74d-b52de1d06448', 'sssss', '2018-02-28 10:14:38', NULL, '0', 0, 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', NULL, NULL, '0', 0, '2018-02-28 10:14:38', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('e9499fca-b1f2-4c07-bef5-5b8b9918ce2e', '2131a\'s\'d', '2018-01-08 09:40:31', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-08 09:40:31', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('ec33f371-e9eb-4da0-a970-aceed958c67b', '好的', '2018-01-11 18:04:46', NULL, '0', 1, 'explanation', '1', NULL, NULL, '0', 0, '2018-01-11 18:04:46', NULL, NULL, '0e568a49-426a-4c0f-8730-2f3d62828c11', 'comment', NULL);
INSERT INTO `discuss` VALUES ('eebcb8d9-56e2-4a19-a5cf-72225157ae72', '14', '2018-02-26 15:54:14', NULL, '0', 1, 'interlocution', '2', NULL, NULL, '0', 0, '2018-02-26 15:54:14', NULL, NULL, 'manager', 'comment', NULL);
INSERT INTO `discuss` VALUES ('f684ca19-281e-4743-8d46-b5bc43b017f4', '岁数大所多', '2018-02-27 16:31:02', NULL, '0', 1, 'interlocution', '1', NULL, NULL, '0', 0, '2018-02-27 16:31:02', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('f9503219-4ba7-4e17-b1ee-dcc2d0bfd14f', 'sssss', '2018-02-28 09:40:25', NULL, '0', 1, 'interlocution', 'c9fbb3b8-d914-4c79-baf9-30d80099b514', NULL, NULL, '0', 0, '2018-02-28 09:40:25', NULL, NULL, 'manager', 'comment', 1);
INSERT INTO `discuss` VALUES ('ffe4d8c8-404b-413a-b5e0-ed3ff4c44d7c', '15', '2018-02-26 16:08:59', NULL, '0', 1, 'interlocution', '1', NULL, NULL, '0', 0, '2018-02-26 16:08:59', NULL, NULL, 'manager', 'comment', 0);
COMMIT;

-- ----------------------------
-- Table structure for disscuss_like
-- ----------------------------
DROP TABLE IF EXISTS `disscuss_like`;
CREATE TABLE `disscuss_like` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `discuss_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK503D415F146ECB25` (`user_id`) USING BTREE,
  KEY `FK503D415F2C25342` (`discuss_id`) USING BTREE,
  CONSTRAINT `FK503D415F146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK503D415F2C25342` FOREIGN KEY (`discuss_id`) REFERENCES `discuss` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of disscuss_like
-- ----------------------------
BEGIN;
INSERT INTO `disscuss_like` VALUES ('01f89e7d-8bc7-499f-916b-fe8743b683e7', '2018-01-10 16:32:16', '2018-01-10 16:32:16', 'd3ea2bf9-c470-4312-8def-a0b1d0fca290', 'manager');
INSERT INTO `disscuss_like` VALUES ('09b23411-228a-45d1-afba-5e845eca092c', '2018-02-26 16:07:46', '2018-02-26 16:07:46', '1c275c57-11cd-4207-8a28-e32ec44b8f48', 'manager');
INSERT INTO `disscuss_like` VALUES ('0b5856cb-18bd-42a0-8c7f-6261eb25a43d', '2018-02-28 09:48:54', '2018-02-28 09:48:54', 'f9503219-4ba7-4e17-b1ee-dcc2d0bfd14f', 'manager');
INSERT INTO `disscuss_like` VALUES ('10ef2ac2-e514-4fed-9fd2-6d710782154c', '2018-01-10 16:37:46', '2018-01-10 16:37:46', 'e9499fca-b1f2-4c07-bef5-5b8b9918ce2e', 'manager');
INSERT INTO `disscuss_like` VALUES ('18941548-241f-4734-88bc-ff1abdc85120', '2018-01-08 18:43:19', '2018-01-08 18:43:19', 'a46bce92-795e-4a8d-a0e3-f4c7b04392ba', 'manager');
INSERT INTO `disscuss_like` VALUES ('1c0f1a70-ed37-4c59-bc1a-9e5a170a5f82', '2018-01-07 12:52:22', '2018-01-07 12:52:22', '74e7ff8e-3c6b-4eda-b532-012b412e73a8', 'manager');
INSERT INTO `disscuss_like` VALUES ('20bf6e7a-4c31-493a-aed9-a99fd715eedd', '2018-01-08 09:33:34', '2018-01-08 09:33:34', 'd7fd80d2-31c9-483d-99b1-b27d5f209053', 'manager');
INSERT INTO `disscuss_like` VALUES ('225359eb-5ac7-46d0-814a-d1a71fc64024', '2018-01-10 16:41:05', '2018-01-10 16:41:05', '2c49658b-534a-4b8e-890d-fc204f4650eb', 'manager');
INSERT INTO `disscuss_like` VALUES ('2f0779b4-7242-49fc-91fb-76ad59960a8e', '2018-01-10 16:44:25', '2018-01-10 16:44:25', '8cc09e53-1e02-44c9-a49c-d061202c3648', 'manager');
INSERT INTO `disscuss_like` VALUES ('2fbebf6a-f73f-414c-ac3f-91aa38804e54', '2018-01-07 12:52:17', '2018-01-07 12:52:17', '07fce550-507e-46c5-98cb-e9675d1c2ed6', 'manager');
INSERT INTO `disscuss_like` VALUES ('3bf71ad1-e4c2-4480-8fb6-55eeb7a2f00a', '2018-01-12 09:39:05', '2018-01-12 09:39:05', '0dd55420-e4f0-4c78-8c14-b1f47e8140ac', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `disscuss_like` VALUES ('46642796-f0e7-4db8-aa99-abc4e233979c', '2018-02-26 16:10:43', '2018-02-26 16:10:43', 'eebcb8d9-56e2-4a19-a5cf-72225157ae72', 'manager');
INSERT INTO `disscuss_like` VALUES ('4938ab2f-510d-4930-93e4-c66d5d5a4efa', '2018-01-10 16:34:58', '2018-01-10 16:34:58', '7efcea42-7332-4842-bd0b-683a19519979', 'manager');
INSERT INTO `disscuss_like` VALUES ('59bf84e1-3fe2-4350-ba4d-5d9193fe15e6', '2018-01-23 10:43:14', '2018-01-23 10:43:14', 'a2f23c94-8a69-463d-915f-6fe54b13e2be', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `disscuss_like` VALUES ('59f62308-d845-4848-87ce-c75de9e53965', '2018-03-07 10:30:36', '2018-03-07 10:30:36', '0ae924ec-a0a3-424a-af77-33595743f7d0', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `disscuss_like` VALUES ('5faa30fd-0dd3-47b9-b8e3-50bfd9284a72', '2018-01-10 13:33:55', '2018-01-10 13:33:55', 'a46bce92-795e-4a8d-a0e3-f4c7b04392ba', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `disscuss_like` VALUES ('61c3e655-35e1-4907-ba42-1d4d0747ee34', '2018-02-27 16:45:24', '2018-02-27 16:45:24', '52dc8df7-116a-4fbd-ae23-0abfbea20dd0', 'manager');
INSERT INTO `disscuss_like` VALUES ('6d35e0e2-6070-46ef-a259-d5eda996be65', '2018-03-07 10:30:46', '2018-03-07 10:30:46', 'f684ca19-281e-4743-8d46-b5bc43b017f4', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `disscuss_like` VALUES ('6df4ff3f-cc7c-4a61-a6f3-95fff73662a6', '2018-01-11 18:46:01', '2018-01-11 18:46:01', 'ec33f371-e9eb-4da0-a970-aceed958c67b', 'manager');
INSERT INTO `disscuss_like` VALUES ('7c55e9f5-038f-42e0-b4f5-60b97950578c', '2018-02-28 15:09:31', '2018-02-28 15:09:31', 'c83b9a5f-4eaa-4b4a-b14c-b7d53d258818', 'manager');
INSERT INTO `disscuss_like` VALUES ('87548658-752d-4205-a90f-2cafa442f556', '2018-02-27 16:46:29', '2018-02-27 16:46:29', '2fe9af84-d89a-4418-a695-ef3abc54b032', 'manager');
INSERT INTO `disscuss_like` VALUES ('9b2a9f95-8209-4465-85e1-9d920ea379e7', '2018-01-11 18:45:58', '2018-01-11 18:45:58', 'a2f23c94-8a69-463d-915f-6fe54b13e2be', 'manager');
INSERT INTO `disscuss_like` VALUES ('a3d257c1-532a-4381-a540-a1a17b934786', '2018-01-07 20:25:11', '2018-01-07 20:25:11', 'c3b89277-84b6-4d3c-a33e-c9431f993cb1', 'manager');
INSERT INTO `disscuss_like` VALUES ('c6cab385-b33b-45f6-96fc-d0844e6ee773', '2018-02-26 15:57:12', '2018-02-26 15:57:12', '029ff85d-fbfa-43f0-a9b5-d3f1d54fb97f', 'manager');
INSERT INTO `disscuss_like` VALUES ('ca4a81ac-4c11-4a57-916d-52ef03dbb981', '2018-01-10 16:39:39', '2018-01-10 16:39:39', '12848e6d-2400-42b7-a437-f44185c54442', 'manager');
INSERT INTO `disscuss_like` VALUES ('ce909870-8226-4598-96b9-49d74f75556f', '2018-02-26 16:09:48', '2018-02-26 16:09:48', '589e59d5-cc08-49b4-8c6a-124bc1e019dd', 'manager');
INSERT INTO `disscuss_like` VALUES ('d208081e-8c26-4dc9-855c-5b02618c0509', '2018-01-10 16:36:03', '2018-01-10 16:36:03', '24d0a045-6c2b-44e5-a334-f4eaa93a07d7', 'manager');
INSERT INTO `disscuss_like` VALUES ('da769376-7cba-4898-825e-75634d0f3945', '2018-03-07 10:30:51', '2018-03-07 10:30:51', 'ffe4d8c8-404b-413a-b5e0-ed3ff4c44d7c', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
COMMIT;

-- ----------------------------
-- Table structure for explanation
-- ----------------------------
DROP TABLE IF EXISTS `explanation`;
CREATE TABLE `explanation` (
  `id` varchar(255) NOT NULL,
  `att_type` bigint(20) DEFAULT NULL,
  `collection_number` int(11) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `discuss_number` int(11) DEFAULT NULL,
  `is_add_integral` bigint(20) DEFAULT NULL,
  `like_number` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read_number` int(11) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `video_att` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKBE15CE19146ECB25` (`user_id`) USING BTREE,
  KEY `FKBE15CE19C6B2B2AA` (`video_att`) USING BTREE,
  CONSTRAINT `FKBE15CE19146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKBE15CE19C6B2B2AA` FOREIGN KEY (`video_att`) REFERENCES `attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of explanation
-- ----------------------------
BEGIN;
INSERT INTO `explanation` VALUES ('1', 9, 2, NULL, '2018-01-06 11:05:52', 17, 10, 17, '从POR到低预后Poseidon组的新分类', 20, 10, 0, '2018-01-06 11:06:47', 'manager', 'video_1');
INSERT INTO `explanation` VALUES ('2', 10, 2, '控制性超促排卵', '2018-01-06 11:05:52', 13, 10, 15, '控制性超促排卵', 20, 10, 0, '2018-01-06 11:06:47', 'manager', NULL);
COMMIT;

-- ----------------------------
-- Table structure for explanation_img_attachment
-- ----------------------------
DROP TABLE IF EXISTS `explanation_img_attachment`;
CREATE TABLE `explanation_img_attachment` (
  `explanation_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK8B903A051D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK8B903A05DA110B4F` (`explanation_id`) USING BTREE,
  CONSTRAINT `FK8B903A051D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK8B903A05DA110B4F` FOREIGN KEY (`explanation_id`) REFERENCES `explanation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of explanation_img_attachment
-- ----------------------------
BEGIN;
INSERT INTO `explanation_img_attachment` VALUES ('1', '1');
INSERT INTO `explanation_img_attachment` VALUES ('1', '2');
INSERT INTO `explanation_img_attachment` VALUES ('1', '3');
INSERT INTO `explanation_img_attachment` VALUES ('1', '4');
INSERT INTO `explanation_img_attachment` VALUES ('1', '5');
INSERT INTO `explanation_img_attachment` VALUES ('1', '6');
INSERT INTO `explanation_img_attachment` VALUES ('1', '7');
INSERT INTO `explanation_img_attachment` VALUES ('1', '8');
INSERT INTO `explanation_img_attachment` VALUES ('1', '9');
INSERT INTO `explanation_img_attachment` VALUES ('1', '10');
INSERT INTO `explanation_img_attachment` VALUES ('1', '11');
INSERT INTO `explanation_img_attachment` VALUES ('1', '12');
INSERT INTO `explanation_img_attachment` VALUES ('1', '13');
INSERT INTO `explanation_img_attachment` VALUES ('1', '14');
INSERT INTO `explanation_img_attachment` VALUES ('1', '15');
INSERT INTO `explanation_img_attachment` VALUES ('1', '16');
INSERT INTO `explanation_img_attachment` VALUES ('1', '17');
INSERT INTO `explanation_img_attachment` VALUES ('1', '18');
INSERT INTO `explanation_img_attachment` VALUES ('1', '19');
INSERT INTO `explanation_img_attachment` VALUES ('1', '20');
INSERT INTO `explanation_img_attachment` VALUES ('1', '21');
INSERT INTO `explanation_img_attachment` VALUES ('1', '22');
INSERT INTO `explanation_img_attachment` VALUES ('1', '23');
INSERT INTO `explanation_img_attachment` VALUES ('1', '24');
INSERT INTO `explanation_img_attachment` VALUES ('1', '25');
INSERT INTO `explanation_img_attachment` VALUES ('1', '26');
INSERT INTO `explanation_img_attachment` VALUES ('1', '27');
INSERT INTO `explanation_img_attachment` VALUES ('1', '28');
INSERT INTO `explanation_img_attachment` VALUES ('1', '29');
INSERT INTO `explanation_img_attachment` VALUES ('1', '30');
INSERT INTO `explanation_img_attachment` VALUES ('1', '31');
INSERT INTO `explanation_img_attachment` VALUES ('1', '32');
INSERT INTO `explanation_img_attachment` VALUES ('1', '33');
INSERT INTO `explanation_img_attachment` VALUES ('1', '34');
INSERT INTO `explanation_img_attachment` VALUES ('1', '35');
INSERT INTO `explanation_img_attachment` VALUES ('1', '36');
INSERT INTO `explanation_img_attachment` VALUES ('1', '37');
INSERT INTO `explanation_img_attachment` VALUES ('1', '38');
INSERT INTO `explanation_img_attachment` VALUES ('2', '1');
INSERT INTO `explanation_img_attachment` VALUES ('2', '2');
INSERT INTO `explanation_img_attachment` VALUES ('2', '3');
INSERT INTO `explanation_img_attachment` VALUES ('2', '4');
INSERT INTO `explanation_img_attachment` VALUES ('2', '5');
INSERT INTO `explanation_img_attachment` VALUES ('2', '6');
INSERT INTO `explanation_img_attachment` VALUES ('2', '7');
INSERT INTO `explanation_img_attachment` VALUES ('2', '8');
INSERT INTO `explanation_img_attachment` VALUES ('2', '9');
INSERT INTO `explanation_img_attachment` VALUES ('2', '10');
INSERT INTO `explanation_img_attachment` VALUES ('2', '11');
INSERT INTO `explanation_img_attachment` VALUES ('2', '12');
INSERT INTO `explanation_img_attachment` VALUES ('2', '13');
INSERT INTO `explanation_img_attachment` VALUES ('2', '14');
INSERT INTO `explanation_img_attachment` VALUES ('2', '15');
INSERT INTO `explanation_img_attachment` VALUES ('2', '16');
INSERT INTO `explanation_img_attachment` VALUES ('2', '17');
INSERT INTO `explanation_img_attachment` VALUES ('2', '18');
INSERT INTO `explanation_img_attachment` VALUES ('2', '19');
INSERT INTO `explanation_img_attachment` VALUES ('2', '20');
INSERT INTO `explanation_img_attachment` VALUES ('2', '21');
INSERT INTO `explanation_img_attachment` VALUES ('2', '22');
INSERT INTO `explanation_img_attachment` VALUES ('2', '23');
INSERT INTO `explanation_img_attachment` VALUES ('2', '24');
INSERT INTO `explanation_img_attachment` VALUES ('2', '25');
INSERT INTO `explanation_img_attachment` VALUES ('2', '26');
INSERT INTO `explanation_img_attachment` VALUES ('2', '27');
INSERT INTO `explanation_img_attachment` VALUES ('2', '28');
INSERT INTO `explanation_img_attachment` VALUES ('2', '29');
INSERT INTO `explanation_img_attachment` VALUES ('2', '30');
INSERT INTO `explanation_img_attachment` VALUES ('2', '31');
INSERT INTO `explanation_img_attachment` VALUES ('2', '32');
INSERT INTO `explanation_img_attachment` VALUES ('2', '33');
INSERT INTO `explanation_img_attachment` VALUES ('2', '34');
INSERT INTO `explanation_img_attachment` VALUES ('2', '35');
INSERT INTO `explanation_img_attachment` VALUES ('2', '36');
INSERT INTO `explanation_img_attachment` VALUES ('2', '37');
INSERT INTO `explanation_img_attachment` VALUES ('2', '38');
COMMIT;

-- ----------------------------
-- Table structure for explanation_literature
-- ----------------------------
DROP TABLE IF EXISTS `explanation_literature`;
CREATE TABLE `explanation_literature` (
  `id` varchar(255) NOT NULL,
  `explanation_id` varchar(255) DEFAULT NULL,
  `literature_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK9F15C337B9404D45` (`literature_id`) USING BTREE,
  KEY `FK9F15C337DA110B4F` (`explanation_id`) USING BTREE,
  CONSTRAINT `FK9F15C337B9404D45` FOREIGN KEY (`literature_id`) REFERENCES `literature` (`id`),
  CONSTRAINT `FK9F15C337DA110B4F` FOREIGN KEY (`explanation_id`) REFERENCES `explanation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of explanation_literature
-- ----------------------------
BEGIN;
INSERT INTO `explanation_literature` VALUES ('1', '1', '6');
INSERT INTO `explanation_literature` VALUES ('2', '2', '6');
COMMIT;

-- ----------------------------
-- Table structure for goods_info
-- ----------------------------
DROP TABLE IF EXISTS `goods_info`;
CREATE TABLE `goods_info` (
  `id` varchar(255) NOT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `inventory` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods_info
-- ----------------------------
BEGIN;
INSERT INTO `goods_info` VALUES ('1', '内容', '2018-03-08 11:04:22', 10, '名称呢过', '12', 1, 1, '2018-03-08 11:04:39');
INSERT INTO `goods_info` VALUES ('2', '内容', '2018-03-08 11:04:54', 15, '名册个', '123', 12, 0, '2018-03-08 11:05:08');
COMMIT;

-- ----------------------------
-- Table structure for goods_order
-- ----------------------------
DROP TABLE IF EXISTS `goods_order`;
CREATE TABLE `goods_order` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `rec_address` varchar(255) DEFAULT NULL,
  `rec_name` varchar(255) DEFAULT NULL,
  `rec_phone` varchar(255) DEFAULT NULL,
  `remark` text,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_remark` text,
  `goods_info_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK1D5829251FD02C85` (`goods_info_id`) USING BTREE,
  KEY `FK1D582925146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK1D582925146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK1D5829251FD02C85` FOREIGN KEY (`goods_info_id`) REFERENCES `goods_info` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods_order
-- ----------------------------
BEGIN;
INSERT INTO `goods_order` VALUES ('68314b02-7999-4df3-a7c6-06d1036f591c', '2018-03-08 16:54:53', NULL, '123', '河南省洛阳市洛龙区sasasasa飒飒多', '傻按时', '17798903668', NULL, 1, '2018-03-08 16:54:53', NULL, '2', 'manager');
INSERT INTO `goods_order` VALUES ('76ba7557-c1f8-4875-bf22-8c2a162c88fa', '2018-03-08 16:25:47', NULL, '123', '河南省洛阳市洛龙区sasasasa飒飒多', '傻按时', '17798903668', NULL, 1, '2018-03-08 16:25:47', NULL, '2', 'manager');
INSERT INTO `goods_order` VALUES ('915b7785-d66e-4f56-adf8-ee219ff0faac', '2018-03-08 16:25:52', NULL, '123', '河南省洛阳市洛龙区sasasasa飒飒多', '傻按时', '17798903668', NULL, 1, '2018-03-08 16:25:52', NULL, '2', 'manager');
INSERT INTO `goods_order` VALUES ('93ff0705-713f-4b70-a8f4-08048b42cad9', '2018-03-08 16:25:01', NULL, '123', '河南省洛阳市洛龙区sasasasa飒飒多', '傻按时', '17798903668', NULL, 1, '2018-03-08 16:25:01', NULL, '2', 'manager');
INSERT INTO `goods_order` VALUES ('b5f863d3-60d1-490f-80d2-da86a6e69869', '2018-03-08 16:25:12', NULL, '123', '河南省洛阳市洛龙区sasasasa飒飒多', '傻按时', '17798903668', NULL, 1, '2018-03-08 16:25:12', NULL, '2', 'manager');
COMMIT;

-- ----------------------------
-- Table structure for interlocution
-- ----------------------------
DROP TABLE IF EXISTS `interlocution`;
CREATE TABLE `interlocution` (
  `id` varchar(255) NOT NULL,
  `att_type` bigint(20) DEFAULT NULL,
  `collection_number` int(11) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `discuss_number` int(11) DEFAULT NULL,
  `like_number` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read_number` int(11) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `video_att` tinyblob,
  `user_id` varchar(255) DEFAULT NULL,
  `integral` int(11) NOT NULL,
  `module` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `is_add_integra` bigint(20) DEFAULT NULL,
  `is_reward` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK73903EA5146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK73903EA5146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of interlocution
-- ----------------------------
BEGIN;
INSERT INTO `interlocution` VALUES ('1', 1, 10, '有问有答的内容00001有问有答的内容00001有问有答的内容00001有问有答的内容00001', '2018-02-26 15:13:16', 11, 10, '1有问有答001', 10, 1, 0, '2018-02-26 15:13:48', NULL, '0be1af05-39c6-424a-8149-32f3d4dd6879', 10, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', 1, 0, '按aaas', '2018-02-28 10:27:53', 2, 0, '按aaas', 0, NULL, 0, '2018-02-28 10:27:53', NULL, 'manager', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('2', 2, 20, '有问有答的内容00002有问有答的内容00002有问有答的内容00002有问有答的内容00002', '2018-02-26 15:13:16', 21, 20, '1有问有答002', 20, 2, 0, '2018-02-26 15:13:48', NULL, '0be1af05-39c6-424a-8149-32f3d4dd6879', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', 1, 0, 'sssss', '2018-02-27 11:42:38', 0, 0, 'sssss', 0, NULL, 0, '2018-02-27 11:42:38', NULL, '5fdb4d70-00bf-4402-b44f-e4eff2821c0b', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('7d11fea4-e628-46be-bcb2-776a3c228778', 1, 1, 'zzzzzzzzzzzzzzz', '2018-02-28 15:11:55', 1, 0, 'zzzzzzzzzzzzzzz', 0, NULL, 0, '2018-02-28 15:11:55', NULL, 'manager', 5, NULL, NULL, 0, NULL);
INSERT INTO `interlocution` VALUES ('9249721b-8861-4e4e-a196-723062f67350', 1, 0, 'ssssssaa', '2018-02-28 15:18:23', 1, 0, 'ssssssaa', 0, NULL, 0, '2018-02-28 15:18:23', NULL, 'manager', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('94455f56-2e5f-459b-ac94-e589afb58ce5', 1, 0, '算时时彩', '2018-02-28 09:38:27', 4, 0, '算时时彩', 0, NULL, 0, '2018-02-28 09:38:27', NULL, 'manager', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('c9fbb3b8-d914-4c79-baf9-30d80099b514', 1, 1, 'asdasd', '2018-02-28 09:39:44', 2, 0, 'asdasd', 0, NULL, 0, '2018-02-28 09:39:44', NULL, 'manager', 0, NULL, NULL, 1, NULL);
INSERT INTO `interlocution` VALUES ('e5565093-899d-4262-8640-535bc07ae490', 1, 0, '按时还是的是的撒就大会上你打大华师大', '2018-02-28 10:18:30', 1, 0, '按时还是的是的撒就大会上你打大华师大', 0, NULL, 0, '2018-02-28 10:18:30', NULL, 'manager', 0, NULL, NULL, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for interlocution_img_attachment
-- ----------------------------
DROP TABLE IF EXISTS `interlocution_img_attachment`;
CREATE TABLE `interlocution_img_attachment` (
  `interlocution_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK1FAD1FF91D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK1FAD1FF93F2C768F` (`interlocution_id`) USING BTREE,
  CONSTRAINT `FK1FAD1FF91D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK1FAD1FF93F2C768F` FOREIGN KEY (`interlocution_id`) REFERENCES `interlocution` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of interlocution_img_attachment
-- ----------------------------
BEGIN;
INSERT INTO `interlocution_img_attachment` VALUES ('1', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `interlocution_img_attachment` VALUES ('1', '12');
INSERT INTO `interlocution_img_attachment` VALUES ('1', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `interlocution_img_attachment` VALUES ('1', '672602a0-3147-41f4-9d8e-1e6f8909da9a');
INSERT INTO `interlocution_img_attachment` VALUES ('2', 'video_1');
INSERT INTO `interlocution_img_attachment` VALUES ('2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', '3a745738-1a79-49e8-ab7e-da03dd91396c');
INSERT INTO `interlocution_img_attachment` VALUES ('94455f56-2e5f-459b-ac94-e589afb58ce5', '210ed2c0-316e-4fc3-9a1d-ce1a347ebe69');
INSERT INTO `interlocution_img_attachment` VALUES ('c9fbb3b8-d914-4c79-baf9-30d80099b514', '3f8f0a23-eccf-47a2-8d63-d952a77d171b');
INSERT INTO `interlocution_img_attachment` VALUES ('e5565093-899d-4262-8640-535bc07ae490', '9765c8f4-e196-4036-aea4-6e194289046d');
INSERT INTO `interlocution_img_attachment` VALUES ('15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', '38cc3005-d463-408e-b716-f2cae342bbf8');
INSERT INTO `interlocution_img_attachment` VALUES ('7d11fea4-e628-46be-bcb2-776a3c228778', 'c7cfccf0-1655-44b8-8666-12f5281082e2');
INSERT INTO `interlocution_img_attachment` VALUES ('9249721b-8861-4e4e-a196-723062f67350', '1f5430f2-ab3c-40e5-ba76-608fcbb28ca4');
COMMIT;

-- ----------------------------
-- Table structure for literature
-- ----------------------------
DROP TABLE IF EXISTS `literature`;
CREATE TABLE `literature` (
  `id` varchar(255) NOT NULL,
  `att_type` bigint(20) DEFAULT NULL,
  `content` text,
  `create_time` datetime DEFAULT NULL,
  `is_add_integral` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read_number` int(11) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `type` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `base_tab` bigint(20) DEFAULT NULL,
  `video_att` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK9800D551146ECB25` (`user_id`) USING BTREE,
  KEY `FK9800D551C6B2B2AA` (`video_att`) USING BTREE,
  CONSTRAINT `FK9800D551146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK9800D551C6B2B2AA` FOREIGN KEY (`video_att`) REFERENCES `attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of literature
-- ----------------------------
BEGIN;
INSERT INTO `literature` VALUES ('1', 2, NULL, '2018-01-02 21:45:16', 1, '从POR到低预后Poseidon组的新分类', 55, 1, 0, 1, '2018-01-02 21:45:29', NULL, NULL, 'video_1');
INSERT INTO `literature` VALUES ('10', 2, NULL, '2018-01-12 14:04:34', 1, 'case-1', 1, 0, 0, 2, '2018-01-12 14:16:13', NULL, 0, 'video_3');
INSERT INTO `literature` VALUES ('11', 2, NULL, '2018-01-12 14:04:36', 1, 'case-2', 1, 0, 0, 2, '2018-01-12 14:16:16', NULL, 0, 'video_4');
INSERT INTO `literature` VALUES ('2', 6, NULL, '2018-01-02 21:45:58', 1, '控制性超促排卵', 18, 0, 0, 1, '2018-01-02 21:46:16', NULL, NULL, NULL);
INSERT INTO `literature` VALUES ('3', 2, NULL, '2018-01-02 21:44:04', 1, '从POR到低预后Poseidon组的新分类', 36, 0, 0, 2, '2018-01-02 21:44:56', NULL, 0, 'video_1');
INSERT INTO `literature` VALUES ('4', 6, NULL, '2018-01-02 21:45:58', 1, '控制性超促排卵', 2, 0, 0, 2, '2018-01-02 21:46:16', NULL, 0, NULL);
INSERT INTO `literature` VALUES ('5', 7, NULL, '2018-01-02 21:45:58', 1, '生殖健康基础培训教材', 15, 0, 0, 2, '2018-01-02 21:46:16', NULL, 0, 'pdf_1');
INSERT INTO `literature` VALUES ('6', 7, NULL, '2018-01-10 02:02:49', 1, '生殖健康基础培训教材', 6, 0, 0, 3, '2018-01-10 02:02:49', NULL, NULL, 'pdf_1');
INSERT INTO `literature` VALUES ('7', 2, NULL, '2018-01-02 21:44:04', 1, '从POR到低预后Poseidon组的新分类', 1, 0, 0, 2, '2018-01-02 21:44:56', NULL, 1, 'video_1');
INSERT INTO `literature` VALUES ('8', 7, NULL, '2018-01-02 21:45:58', 1, '生殖健康基础培训教材', 0, 0, 0, 2, '2018-01-02 21:46:16', NULL, 1, 'pdf_1');
INSERT INTO `literature` VALUES ('9', 2, NULL, '2018-01-12 14:04:32', 1, '基础内分泌及卵泡形成', 2, 0, 0, 2, '2018-01-12 14:16:10', NULL, 0, 'video_2');
COMMIT;

-- ----------------------------
-- Table structure for literature_down_attachment
-- ----------------------------
DROP TABLE IF EXISTS `literature_down_attachment`;
CREATE TABLE `literature_down_attachment` (
  `literature_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK2A8A19F21D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK2A8A19F2B9404D45` (`literature_id`) USING BTREE,
  CONSTRAINT `FK2A8A19F21D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK2A8A19F2B9404D45` FOREIGN KEY (`literature_id`) REFERENCES `literature` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for literature_img_attachment
-- ----------------------------
DROP TABLE IF EXISTS `literature_img_attachment`;
CREATE TABLE `literature_img_attachment` (
  `literature_id` varchar(255) NOT NULL,
  `attachment_id` varchar(255) NOT NULL,
  KEY `FK933EDBCD1D6A0B84` (`attachment_id`) USING BTREE,
  KEY `FK933EDBCDB9404D45` (`literature_id`) USING BTREE,
  CONSTRAINT `FK933EDBCD1D6A0B84` FOREIGN KEY (`attachment_id`) REFERENCES `attachment` (`id`),
  CONSTRAINT `FK933EDBCDB9404D45` FOREIGN KEY (`literature_id`) REFERENCES `literature` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of literature_img_attachment
-- ----------------------------
BEGIN;
INSERT INTO `literature_img_attachment` VALUES ('4', '1');
INSERT INTO `literature_img_attachment` VALUES ('4', '2');
INSERT INTO `literature_img_attachment` VALUES ('4', '3');
INSERT INTO `literature_img_attachment` VALUES ('4', '4');
INSERT INTO `literature_img_attachment` VALUES ('4', '5');
INSERT INTO `literature_img_attachment` VALUES ('4', '6');
INSERT INTO `literature_img_attachment` VALUES ('4', '7');
INSERT INTO `literature_img_attachment` VALUES ('4', '8');
INSERT INTO `literature_img_attachment` VALUES ('4', '9');
INSERT INTO `literature_img_attachment` VALUES ('4', '10');
INSERT INTO `literature_img_attachment` VALUES ('4', '11');
INSERT INTO `literature_img_attachment` VALUES ('4', '12');
INSERT INTO `literature_img_attachment` VALUES ('4', '13');
INSERT INTO `literature_img_attachment` VALUES ('4', '14');
INSERT INTO `literature_img_attachment` VALUES ('4', '15');
INSERT INTO `literature_img_attachment` VALUES ('4', '16');
INSERT INTO `literature_img_attachment` VALUES ('4', '17');
INSERT INTO `literature_img_attachment` VALUES ('4', '18');
INSERT INTO `literature_img_attachment` VALUES ('4', '19');
INSERT INTO `literature_img_attachment` VALUES ('4', '20');
INSERT INTO `literature_img_attachment` VALUES ('4', '21');
INSERT INTO `literature_img_attachment` VALUES ('4', '22');
INSERT INTO `literature_img_attachment` VALUES ('4', '23');
INSERT INTO `literature_img_attachment` VALUES ('4', '24');
INSERT INTO `literature_img_attachment` VALUES ('4', '25');
INSERT INTO `literature_img_attachment` VALUES ('4', '26');
INSERT INTO `literature_img_attachment` VALUES ('4', '27');
INSERT INTO `literature_img_attachment` VALUES ('4', '28');
INSERT INTO `literature_img_attachment` VALUES ('4', '29');
INSERT INTO `literature_img_attachment` VALUES ('4', '30');
INSERT INTO `literature_img_attachment` VALUES ('4', '31');
INSERT INTO `literature_img_attachment` VALUES ('4', '32');
INSERT INTO `literature_img_attachment` VALUES ('4', '33');
INSERT INTO `literature_img_attachment` VALUES ('4', '34');
INSERT INTO `literature_img_attachment` VALUES ('4', '35');
INSERT INTO `literature_img_attachment` VALUES ('4', '36');
INSERT INTO `literature_img_attachment` VALUES ('4', '37');
INSERT INTO `literature_img_attachment` VALUES ('4', '38');
INSERT INTO `literature_img_attachment` VALUES ('2', '1');
INSERT INTO `literature_img_attachment` VALUES ('2', '2');
INSERT INTO `literature_img_attachment` VALUES ('2', '3');
INSERT INTO `literature_img_attachment` VALUES ('2', '4');
INSERT INTO `literature_img_attachment` VALUES ('2', '5');
INSERT INTO `literature_img_attachment` VALUES ('2', '6');
INSERT INTO `literature_img_attachment` VALUES ('2', '7');
INSERT INTO `literature_img_attachment` VALUES ('2', '8');
INSERT INTO `literature_img_attachment` VALUES ('2', '9');
INSERT INTO `literature_img_attachment` VALUES ('2', '10');
INSERT INTO `literature_img_attachment` VALUES ('2', '11');
INSERT INTO `literature_img_attachment` VALUES ('2', '12');
INSERT INTO `literature_img_attachment` VALUES ('2', '13');
INSERT INTO `literature_img_attachment` VALUES ('2', '14');
INSERT INTO `literature_img_attachment` VALUES ('2', '15');
INSERT INTO `literature_img_attachment` VALUES ('2', '16');
INSERT INTO `literature_img_attachment` VALUES ('2', '17');
INSERT INTO `literature_img_attachment` VALUES ('2', '18');
INSERT INTO `literature_img_attachment` VALUES ('2', '19');
INSERT INTO `literature_img_attachment` VALUES ('2', '20');
INSERT INTO `literature_img_attachment` VALUES ('2', '21');
INSERT INTO `literature_img_attachment` VALUES ('2', '22');
INSERT INTO `literature_img_attachment` VALUES ('2', '23');
INSERT INTO `literature_img_attachment` VALUES ('2', '24');
INSERT INTO `literature_img_attachment` VALUES ('2', '25');
INSERT INTO `literature_img_attachment` VALUES ('2', '26');
INSERT INTO `literature_img_attachment` VALUES ('2', '27');
INSERT INTO `literature_img_attachment` VALUES ('2', '28');
INSERT INTO `literature_img_attachment` VALUES ('2', '29');
INSERT INTO `literature_img_attachment` VALUES ('2', '30');
INSERT INTO `literature_img_attachment` VALUES ('2', '31');
INSERT INTO `literature_img_attachment` VALUES ('2', '32');
INSERT INTO `literature_img_attachment` VALUES ('2', '33');
INSERT INTO `literature_img_attachment` VALUES ('2', '34');
INSERT INTO `literature_img_attachment` VALUES ('2', '35');
INSERT INTO `literature_img_attachment` VALUES ('2', '36');
INSERT INTO `literature_img_attachment` VALUES ('2', '37');
INSERT INTO `literature_img_attachment` VALUES ('2', '38');
COMMIT;

-- ----------------------------
-- Table structure for operatelog
-- ----------------------------
DROP TABLE IF EXISTS `operatelog`;
CREATE TABLE `operatelog` (
  `id` varchar(255) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `createtime` varchar(255) DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `userid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK3DFB40EB5F0F3C` (`userid`) USING BTREE,
  KEY `FK3DFB403CD320F5` (`userid`) USING BTREE,
  CONSTRAINT `FK3DFB403CD320F5` FOREIGN KEY (`userid`) REFERENCES `sys_admin_user` (`id`),
  CONSTRAINT `FK3DFB40EB5F0F3C` FOREIGN KEY (`userid`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for question_bank_answer
-- ----------------------------
DROP TABLE IF EXISTS `question_bank_answer`;
CREATE TABLE `question_bank_answer` (
  `id` varchar(255) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `question_bank_info_id` varchar(255) DEFAULT NULL,
  `question_bank_item_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK5BC5EC487A786294` (`question_bank_info_id`) USING BTREE,
  KEY `FK5BC5EC4884A68C74` (`question_bank_item_id`) USING BTREE,
  KEY `FK5BC5EC48146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK5BC5EC48146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK5BC5EC487A786294` FOREIGN KEY (`question_bank_info_id`) REFERENCES `question_bank_info` (`id`),
  CONSTRAINT `FK5BC5EC4884A68C74` FOREIGN KEY (`question_bank_item_id`) REFERENCES `question_bank_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of question_bank_answer
-- ----------------------------
BEGIN;
INSERT INTO `question_bank_answer` VALUES ('37a8d75a-a41d-4719-8817-5e0bda068472', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', '05f76541-b307-4a91-a535-1cfc351365a8', '084e92d3-d2d2-4c31-b301-26efc8724ed1', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('6049942a-ee91-4798-a518-1cdf0a601b01', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', 'db1b73be-6702-4f2c-99b2-7a84d620e3f0', '551d5dfd-9fb8-448a-97e9-950f04245217', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('673ae1a1-77b4-4d07-96f1-2aa03c2ed9ed', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', 'c8b6692c-3654-4dd3-8edc-cf46f1880c60', 'dcac7dc3-575b-416d-826b-1c5572209cd7', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('7210af60-bd93-463f-abcb-f5448b551d54', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', '5e0f4031-73e7-496e-b652-c4060ad76160', '7c67c4ae-cbe5-4548-b8c9-944d5c81680e', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('7fb9fad2-e264-4148-a37f-d21d3b1e463e', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', 'ec590cba-1391-4b98-9b79-cf84ab2a7bbb', 'd684fc39-0518-4080-bf5d-ee31a425d1af', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('84b2bc85-f161-4fc5-9be9-f8e4c6cac9ca', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', 'e5c5414b-db67-4c3a-a4d8-d25230c6bf87', 'ac7147a2-2739-433a-9433-eba2d6a66b9d', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('869145ab-197e-48aa-a797-a64839c2cf4d', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', '3a490819-8d87-48d4-b2da-1d3370325723', '23e36b6f-b45a-43b7-a730-5dc82f12777a', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('a58daca5-69b2-41f3-b86f-22c6ec026c9f', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', '2dcb6c43-c0ee-4e58-a20c-b714ea125353', '81fed1c3-aad8-46e1-9ef5-083ac1ce48f8', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('f768c084-a7a6-44b5-b0f6-2ff0ab5285c1', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', 'aa2ab2ef-677d-4e32-bd14-02321e7d050b', '58eb1c1a-e5d6-46eb-b3e5-0e1c07371e6d', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
INSERT INTO `question_bank_answer` VALUES ('f9dbfa53-a2ed-4ce0-95ac-004b6384040d', NULL, '2018-01-11 19:23:01', 0, '2018-01-11 19:23:01', '865305e1-7498-4ed0-956f-31807ad79c60', 'bb6e229f-cf00-486e-bec0-9443db1c3ef9', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
COMMIT;

-- ----------------------------
-- Table structure for question_bank_info
-- ----------------------------
DROP TABLE IF EXISTS `question_bank_info`;
CREATE TABLE `question_bank_info` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `info_content` varchar(255) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `type` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of question_bank_info
-- ----------------------------
BEGIN;
INSERT INTO `question_bank_info` VALUES ('024277d2-8b12-4942-ae88-f4a2c6249b60', '2018-01-08 15:53:04', '果纳芬®30个批次的蛋白含量批次间差异仅为多少', 2, 0, 1, '2018-01-08 15:53:04');
INSERT INTO `question_bank_info` VALUES ('029e3e2d-6747-418f-b04b-a065ce3583ca', '2018-01-08 17:30:34', '为什么说质量标称的重组FSH是Gn用于促排卵的最佳选择：', 1, 0, 2, '2018-01-08 17:30:34');
INSERT INTO `question_bank_info` VALUES ('05b1db14-2cee-40d2-930a-2e9813ac763f', '2018-01-08 17:43:54', '哪类人群可从LH活性成分补充中获益', 1, 0, 2, '2018-01-08 17:43:54');
INSERT INTO `question_bank_info` VALUES ('05f76541-b307-4a91-a535-1cfc351365a8', '2018-01-08 19:34:01', '雪诺同®8%何时上药比较好？', 2, 0, 1, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('090b2a6c-77ff-4f1e-9326-e13922cf3140', '2018-01-08 19:40:03', '以下关于累积活产率或累积妊娠率说法正确的是', 1, 0, 1, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('0f83d7c2-f025-4bc5-bfd3-f2acc8a91502', '2018-01-08 17:16:13', '关于扳机选择，说法正确的是', 5, 0, 1, '2018-01-08 17:16:13');
INSERT INTO `question_bank_info` VALUES ('1097860e-9878-446c-b960-c25a3ad35c53', '2018-01-08 19:45:52', '拮抗剂方案中使用GnRH激动剂扳机，黄体支持方案以下哪几项正确？', 1, 0, 2, '2018-01-08 19:45:52');
INSERT INTO `question_bank_info` VALUES ('17cc5490-a1d0-4fd5-9656-23f261220ca7', '2018-01-08 19:45:52', '思则凯的贮藏要求为：', 5, 0, 1, '2018-01-08 19:45:52');
INSERT INTO `question_bank_info` VALUES ('1da69100-4d0d-4078-9aa8-0aa4a7f664a6', '2018-01-08 17:30:34', '关于高龄患者，补充LH说法正确的是', 2, 0, 2, '2018-01-08 17:30:34');
INSERT INTO `question_bank_info` VALUES ('251552ba-b6b4-4dc5-8817-4f614888bff4', '2018-01-08 17:16:13', '关于卵巢高反应人群的特征，说法正确的是', 1, 0, 2, '2018-01-08 17:16:13');
INSERT INTO `question_bank_info` VALUES ('29fc7f00-6f9f-43d0-9ed0-2feb1f7b9a6c', '2018-01-08 19:40:03', '以下能反驳“u-FSH源于原料天然，比果纳芬®疗效更好”这一说法的是', 2, 0, 2, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('2c5df3ae-58c6-4532-8cb6-dd8bc9f42663', '2018-01-08 17:16:13', '关于果纳芬®对比uFSH的获益，正确的是', 2, 0, 2, '2018-01-08 17:16:13');
INSERT INTO `question_bank_info` VALUES ('2cb82d7e-9ffa-4dbf-8f53-b7798d7d6d85', '2018-01-08 17:11:07', '对国产rFSH和果纳芬®说法正确的是', 2, 0, 1, '2018-01-08 17:11:07');
INSERT INTO `question_bank_info` VALUES ('2dcb6c43-c0ee-4e58-a20c-b714ea125353', '2018-01-08 19:34:01', '根据雪诺同推广策略，以下哪几类患者类型是优先推广的目标患者类型？', 1, 0, 2, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('2e782273-6c37-4af7-b008-d42866d36371', '2018-01-08 17:23:26', '正常反应人群中常用的促排卵方案有哪些', 6, 0, 2, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('2ebf9f9b-feb5-498a-bf66-3a938bed32e3', '2018-01-08 17:43:54', '在本周期雪诺同核心DA中雪诺同®8%用药后多少小时子宫内膜达到稳定药物浓度', 5, 0, 1, '2018-01-08 17:43:54');
INSERT INTO `question_bank_info` VALUES ('37b6a7e5-8f7c-4fe8-8fe8-a9f46daef9e2', '2018-01-08 19:40:03', '黄体支持中不同黄体酮给药方式的药代动力学特征以下哪几项正确？', 5, 0, 2, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('3a490819-8d87-48d4-b2da-1d3370325723', '2018-01-08 17:39:33', '相比rFSH-β笔，对果纳芬®笔说法正确的是', 1, 0, 2, '2018-01-08 17:39:33');
INSERT INTO `question_bank_info` VALUES ('3ae955dc-b5ef-47df-b51a-cb959ca418bb', '2018-01-08 16:27:23', '关于累积活产率的影响因素，下列说法正确的是', 1, 0, 2, '2018-01-08 16:27:23');
INSERT INTO `question_bank_info` VALUES ('40857b1b-b937-4595-8330-3a2861e38102', '2018-01-08 19:40:03', '有关对比u-FSH的故事线，表述正确的是', 3, 0, 2, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('45746f49-e7eb-4374-9218-de6407a82146', '2018-01-08 15:53:04', 'IVF 治疗最终目的是', 3, 0, 1, '2018-01-08 15:53:04');
INSERT INTO `question_bank_info` VALUES ('4cbed08b-f802-4374-90cc-9cafec6bb65a', '2018-01-08 19:40:03', '为获得最佳卵泡发育，下列说法正确的是', 4, 0, 1, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('573e0536-e282-4ad7-9c94-6b7ba1282082', '2018-01-08 19:40:03', '妊娠后，由黄体分泌的对维持妊娠起重要作用的激素是哪种激素？', 6, 0, 1, '2018-01-08 19:40:03');
INSERT INTO `question_bank_info` VALUES ('577721a2-cab9-488c-b61d-4a71dd3b4453', '2018-01-08 17:43:54', '由于雪诺同的持续释放特性，黄体酮吸收延长，吸收半衰期为', 4, 0, 1, '2018-01-08 17:43:54');
INSERT INTO `question_bank_info` VALUES ('587da604-f054-450b-891c-de3816b6c38e', '2018-01-08 16:40:32', '卵巢高反应患者临床常用治疗方案是', 1, 0, 1, '2018-01-08 16:40:32');
INSERT INTO `question_bank_info` VALUES ('5bda84d6-71d6-41e8-b556-d87d347c4ae5', '2018-01-08 16:18:17', '关于IVF质控说法正确的是', 1, 0, 2, '2018-01-08 16:18:17');
INSERT INTO `question_bank_info` VALUES ('5e0f4031-73e7-496e-b652-c4060ad76160', '2018-01-08 19:45:52', '思则凯®的禁忌包括', 4, 0, 2, '2018-01-08 19:45:52');
INSERT INTO `question_bank_info` VALUES ('647cff5f-ed3e-466f-88f7-4668b501f443', '2018-01-08 19:34:01', '与u-FSH相比，果纳芬®促排效能更高，下列说法恰当的是', 5, 0, 2, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('6852a676-98e2-49ef-b188-a3125af762a5', '2018-01-08 19:34:01', '针对雪诺同在黄体支持后期被替换，我们有如下对策：', 3, 0, 2, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('6a56e141-0c1f-4362-bf32-f3a66a05e861', '2018-01-08 17:23:26', '正常反应人群治疗目标是什么', 7, 0, 2, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('74bfd8cc-0fef-445d-b0fa-873499c2cc2e', '2018-01-08 17:23:26', '果纳芬®笔最小调节剂量是多少', 1, 0, 1, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('782ce4a2-f3dd-4f0d-9450-0bd62f33755f', '2018-01-08 19:34:01', '关于雪诺同90mg药代动力学特征Cmax（ng/ml）（最大血清浓度）正确的是哪项', 4, 0, 1, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('8502d1f3-1898-44b7-8178-3c7b5b50925b', '2018-01-08 15:53:04', '国产rFSH 6个批次的蛋白含量批次间差异为多少', 1, 0, 1, '2018-01-08 15:53:04');
INSERT INTO `question_bank_info` VALUES ('865305e1-7498-4ed0-956f-31807ad79c60', '2018-01-08 17:23:26', '对于果纳芬®质量标称来说下列说法正确的是', 4, 0, 2, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('951974da-1ca0-49d6-bc99-16be87e5b8a3', '2018-01-08 17:23:26', '果纳芬®适应症', 3, 0, 2, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('9955b355-2061-4243-a9d6-b909476d2dcf', '2018-01-08 19:45:52', '冷冻周期胚胎移植内膜准备方法主要包括', 2, 0, 2, '2018-01-08 19:45:52');
INSERT INTO `question_bank_info` VALUES ('9f6e3e8c-d396-4f4e-af50-1b9c9d48c970', '2018-01-08 17:11:07', '果纳芬®预充注射笔包含哪种规格', 1, 0, 1, '2018-01-08 17:11:07');
INSERT INTO `question_bank_info` VALUES ('aa2ab2ef-677d-4e32-bd14-02321e7d050b', '2018-01-08 17:16:13', '关于果纳芬®对比rFSH-β的获益，正确的是', 4, 0, 1, '2018-01-08 17:16:13');
INSERT INTO `question_bank_info` VALUES ('ba71ff72-d31c-4b3c-b83d-eea85082626c', '2018-01-08 17:43:54', '使用雪诺同如果出现早期出血，我们推荐的处理方法？', 3, 0, 1, '2018-01-08 17:43:54');
INSERT INTO `question_bank_info` VALUES ('bda6f097-fbdc-4d95-b23d-2fab57331dcc', '2018-01-08 19:34:01', '与u-FSH相比，果纳芬®应用于新鲜周期的优势包括', 6, 0, 2, '2018-01-08 19:34:01');
INSERT INTO `question_bank_info` VALUES ('bdabfa2a-bc38-4fe0-a029-c35ca1106983', '2018-01-08 17:30:34', '理想的Gn药物有哪些特性', 4, 0, 2, '2018-01-08 17:30:34');
INSERT INTO `question_bank_info` VALUES ('c8b6692c-3654-4dd3-8edc-cf46f1880c60', '2018-01-08 17:30:34', '关于正常反应人群，说法正确的是', 3, 0, 2, '2018-01-08 17:30:34');
INSERT INTO `question_bank_info` VALUES ('db1b73be-6702-4f2c-99b2-7a84d620e3f0', '2018-01-08 17:45:38', '子宫内膜的分泌期与卵巢的哪一期相对应？', 1, 0, 1, '2018-01-08 17:45:38');
INSERT INTO `question_bank_info` VALUES ('e088f9fd-0dbc-4681-ad83-ebdf5d4cf089', '2018-01-08 17:16:13', '关于果纳芬®和uFSH的FSH异构体含量，说法正确的是', 3, 0, 2, '2018-01-08 17:16:13');
INSERT INTO `question_bank_info` VALUES ('e5c5414b-db67-4c3a-a4d8-d25230c6bf87', '2018-01-08 17:23:26', '果纳芬®针剂规格为多少', 2, 0, 1, '2018-01-08 17:23:26');
INSERT INTO `question_bank_info` VALUES ('ec590cba-1391-4b98-9b79-cf84ab2a7bbb', '2018-01-08 17:39:33', '关于累积活产率，下列说法正确的是', 2, 0, 2, '2018-01-08 17:39:33');
INSERT INTO `question_bank_info` VALUES ('eeca2022-6f1b-47f9-a36c-d900917e92c4', '2018-01-08 17:43:54', '关于雪诺同给药器的使用哪几项正确', 2, 0, 2, '2018-01-08 17:43:54');
INSERT INTO `question_bank_info` VALUES ('f6e0b9bf-87fa-4d3d-aed0-83071b58d17f', '2018-01-08 19:45:52', '下列有关患者自我注射思则凯®的说法正确的是', 3, 0, 1, '2018-01-08 19:45:52');
INSERT INTO `question_bank_info` VALUES ('f7553cd1-f342-473d-84e0-2e86bfccf2ec', '2018-01-08 17:23:26', '卵巢低反应的定义包括哪些', 5, 0, 2, '2018-01-08 17:23:26');
COMMIT;

-- ----------------------------
-- Table structure for question_bank_item
-- ----------------------------
DROP TABLE IF EXISTS `question_bank_item`;
CREATE TABLE `question_bank_item` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `is_key` bigint(20) DEFAULT NULL,
  `option_content` varchar(4000) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `question_bank_info_id` varchar(255) DEFAULT NULL,
  `type` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKB762C21D7A786294` (`question_bank_info_id`) USING BTREE,
  CONSTRAINT `FKB762C21D7A786294` FOREIGN KEY (`question_bank_info_id`) REFERENCES `question_bank_info` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of question_bank_item
-- ----------------------------
BEGIN;
INSERT INTO `question_bank_item` VALUES ('0135e3c9-f485-4d7b-8979-d2e2daceb49d', '2018-01-08 17:39:33', 1, '可用胚胎数越多，整倍体卵母细胞和胚胎越多', 4, 0, '2018-01-08 17:39:33', 'ec590cba-1391-4b98-9b79-cf84ab2a7bbb', 1);
INSERT INTO `question_bank_item` VALUES ('032227f4-82f9-4da1-8913-2b56b3cd929a', '2018-01-08 17:30:34', 1, '重组FSH无污染危险', 1, 0, '2018-01-08 17:30:34', '029e3e2d-6747-418f-b04b-a065ce3583ca', 1);
INSERT INTO `question_bank_item` VALUES ('037bb092-f256-479b-a1d4-91bc74709d66', '2018-01-08 17:11:07', 2, '国产rFSH是果纳芬®的仿制品', 1, 0, '2018-01-08 17:11:07', '2cb82d7e-9ffa-4dbf-8f53-b7798d7d6d85', 1);
INSERT INTO `question_bank_item` VALUES ('057d3625-f590-4a5f-bb4f-1f2c7f9b1375', '2018-01-08 19:45:52', 2, '多胚内膜准备', 4, 0, '2018-01-08 19:45:52', '9955b355-2061-4243-a9d6-b909476d2dcf', 1);
INSERT INTO `question_bank_item` VALUES ('06810eb9-049f-40f2-8794-04b21d22cff5', '2018-01-08 19:34:01', 2, '大于60mg肌注黄体酮', 2, 0, '2018-01-08 19:34:01', '782ce4a2-f3dd-4f0d-9450-0bd62f33755f', 1);
INSERT INTO `question_bank_item` VALUES ('06c5d9a2-bf82-40b9-a10e-d54e9375f635', '2018-01-08 17:16:13', 1, '获卵数', 3, 0, '2018-01-08 17:16:13', '2c5df3ae-58c6-4532-8cb6-dd8bc9f42663', 1);
INSERT INTO `question_bank_item` VALUES ('07819415-e129-442a-a88c-6b35d6727213', '2018-01-08 17:39:33', 1, '阅读训练手册时间短', 3, 0, '2018-01-08 17:39:33', '3a490819-8d87-48d4-b2da-1d3370325723', 1);
INSERT INTO `question_bank_item` VALUES ('084e92d3-d2d2-4c31-b301-26efc8724ed1', '2018-01-08 19:34:01', 1, '早上', 1, 0, '2018-01-08 19:34:01', '05f76541-b307-4a91-a535-1cfc351365a8', 1);
INSERT INTO `question_bank_item` VALUES ('09520582-0506-47b2-9e4d-69ab51f4fb55', '2018-01-08 17:23:26', 1, '累积妊娠率', 3, 0, '2018-01-08 17:23:26', '6a56e141-0c1f-4362-bf32-f3a66a05e861', 1);
INSERT INTO `question_bank_item` VALUES ('0a5ad556-ad6c-4097-bb2f-1599988e9d74', '2018-01-08 17:23:26', 2, '微刺激方案', 1, 0, '2018-01-08 17:23:26', '2e782273-6c37-4af7-b008-d42866d36371', 1);
INSERT INTO `question_bank_item` VALUES ('0ce8fe15-d586-4bb3-b87a-ad9b314f723d', '2018-01-08 19:34:01', 1, '推广雪诺同足疗程治疗理念', 1, 0, '2018-01-08 19:34:01', '6852a676-98e2-49ef-b188-a3125af762a5', 1);
INSERT INTO `question_bank_item` VALUES ('0d60cc7c-a55c-414f-83fe-889d24029421', '2018-01-08 19:45:52', 2, '配制的溶液应立即使用', 1, 0, '2018-01-08 19:45:52', 'f6e0b9bf-87fa-4d3d-aed0-83071b58d17f', 1);
INSERT INTO `question_bank_item` VALUES ('0db2c80b-c6e8-42f2-837e-9db1b0fbe448', '2018-01-08 17:23:26', 1, 'HH(低促性腺激素性性腺功能减退症)', 3, 0, '2018-01-08 17:23:26', '951974da-1ca0-49d6-bc99-16be87e5b8a3', 1);
INSERT INTO `question_bank_item` VALUES ('0eb615b2-24f7-4e3c-85ec-1ad65719e06e', '2018-01-08 17:11:07', 2, '100IU', 1, 0, '2018-01-08 17:11:07', '9f6e3e8c-d396-4f4e-af50-1b9c9d48c970', 1);
INSERT INTO `question_bank_item` VALUES ('0f63c61c-1f4b-4a34-99ff-88e4faf9a593', '2018-01-08 16:40:32', 2, '改良超长方案', 1, 0, '2018-01-08 16:40:32', '587da604-f054-450b-891c-de3816b6c38e', 1);
INSERT INTO `question_bank_item` VALUES ('0fe9b72b-2e06-436c-93e2-619421b7c3a9', '2018-01-08 17:11:07', 1, '300 IU ', 3, 0, '2018-01-08 17:11:07', '9f6e3e8c-d396-4f4e-af50-1b9c9d48c970', 1);
INSERT INTO `question_bank_item` VALUES ('1122bd99-1efc-4c74-b6a4-4bd46d120447', '2018-01-08 17:30:34', 1, '高龄患者添加LH，提高着床率', 2, 0, '2018-01-08 17:30:34', '1da69100-4d0d-4078-9aa8-0aa4a7f664a6', 1);
INSERT INTO `question_bank_item` VALUES ('11a4c7e8-612c-4070-87ed-cd5c1846d760', '2018-01-08 19:40:03', 2, 'LH水平应该超过LH上限', 3, 0, '2018-01-08 19:40:03', '4cbed08b-f802-4374-90cc-9cafec6bb65a', 1);
INSERT INTO `question_bank_item` VALUES ('13c8df5d-b85e-4156-a0a7-1a744f4d56ed', '2018-01-08 15:53:04', 2, 'D.±1.8%', 4, 0, '2018-01-08 15:53:04', '024277d2-8b12-4942-ae88-f4a2c6249b60', 1);
INSERT INTO `question_bank_item` VALUES ('14b6dc43-34ce-47f3-9cb4-1e06c0c2d920', '2018-01-08 16:40:32', 2, '温和刺激方案', 3, 0, '2018-01-08 16:40:32', '587da604-f054-450b-891c-de3816b6c38e', 1);
INSERT INTO `question_bank_item` VALUES ('14c68b31-f9fc-4600-8cb0-a66e92dbde57', '2018-01-08 19:45:52', 2, '单胚内膜准备', 3, 0, '2018-01-08 19:45:52', '9955b355-2061-4243-a9d6-b909476d2dcf', 1);
INSERT INTO `question_bank_item` VALUES ('15a613c1-49dd-4d22-aa69-d96c7582a4cc', '2018-01-08 19:45:52', 1, '进行黄体支持强化治疗有两种方法：1、HCG黄体补救，2、加强雌孕激素治疗', 4, 0, '2018-01-08 19:45:52', '1097860e-9878-446c-b960-c25a3ad35c53', 1);
INSERT INTO `question_bank_item` VALUES ('15be9df1-9f7c-4908-966d-067fccbaab5f', '2018-01-08 17:23:26', 1, 'ART(IVF、GIFT、ZIFT)中进行超排卵的妇女', 2, 0, '2018-01-08 17:23:26', '951974da-1ca0-49d6-bc99-16be87e5b8a3', 1);
INSERT INTO `question_bank_item` VALUES ('15f7f50b-3e52-45b3-a234-7b40d93248d9', '2018-01-08 17:16:13', 2, '获卵数', 3, 0, '2018-01-08 17:16:13', 'aa2ab2ef-677d-4e32-bd14-02321e7d050b', 1);
INSERT INTO `question_bank_item` VALUES ('171cb4b4-b26f-4768-a3b6-48bd48ef400e', '2018-01-08 19:34:01', 2, '大于90mg肌注黄体酮', 3, 0, '2018-01-08 19:34:01', '782ce4a2-f3dd-4f0d-9450-0bd62f33755f', 1);
INSERT INTO `question_bank_item` VALUES ('17243001-4dfa-4f57-beed-604c205599b8', '2018-01-08 17:23:26', 1, '12.5 IU', 3, 0, '2018-01-08 17:23:26', '74bfd8cc-0fef-445d-b0fa-873499c2cc2e', 1);
INSERT INTO `question_bank_item` VALUES ('1832876d-afc6-4111-be98-96c32c5724ea', '2018-01-08 17:43:54', 1, '高龄', 4, 0, '2018-01-08 17:43:54', '05b1db14-2cee-40d2-930a-2e9813ac763f', 1);
INSERT INTO `question_bank_item` VALUES ('1ab732dc-2803-4f76-998e-36a6e5b85c88', '2018-01-08 17:11:07', 2, '400IU', 4, 0, '2018-01-08 17:11:07', '9f6e3e8c-d396-4f4e-af50-1b9c9d48c970', 1);
INSERT INTO `question_bank_item` VALUES ('1b2439d8-cbdd-42d1-a051-39ffb420457c', '2018-01-08 19:45:52', 1, '对醋酸西曲瑞克过敏者', 4, 0, '2018-01-08 19:45:52', '5e0f4031-73e7-496e-b652-c4060ad76160', 1);
INSERT INTO `question_bank_item` VALUES ('1b68e555-eb64-4940-b599-58d8955cc502', '2018-01-08 17:45:38', 1, '黄体期', 2, 0, '2018-01-08 17:45:38', 'db1b73be-6702-4f2c-99b2-7a84d620e3f0', 1);
INSERT INTO `question_bank_item` VALUES ('1bcaebbd-b9f0-4649-b4af-3923ad31004f', '2018-01-08 15:53:04', 2, 'B.±1.4%', 2, 0, '2018-01-08 15:53:04', '024277d2-8b12-4942-ae88-f4a2c6249b60', 1);
INSERT INTO `question_bank_item` VALUES ('1bd129b5-61fd-4888-acc9-3679f7dab36a', '2018-01-08 17:43:54', 2, '2-3小时', 2, 0, '2018-01-08 17:43:54', '2ebf9f9b-feb5-498a-bf66-3a938bed32e3', 1);
INSERT INTO `question_bank_item` VALUES ('1c0692dc-b1a4-435b-b74c-2abb80eef2b2', '2018-01-08 17:23:26', 1, 'GnRH拮抗剂固定方案', 4, 0, '2018-01-08 17:23:26', '2e782273-6c37-4af7-b008-d42866d36371', 1);
INSERT INTO `question_bank_item` VALUES ('1e0e9ad3-46de-4c1a-b91e-ac3739d30a89', '2018-01-08 17:30:34', 2, 'NOR首选推荐方案为拮抗剂方案', 3, 0, '2018-01-08 17:30:34', 'c8b6692c-3654-4dd3-8edc-cf46f1880c60', 1);
INSERT INTO `question_bank_item` VALUES ('1e9e5eb7-b7e8-4b82-80a4-84b55fe4ae50', '2018-01-08 19:40:03', 1, '口服黄体酮绝大部分被肝脏代谢，生物利用度低', 1, 0, '2018-01-08 19:40:03', '37b6a7e5-8f7c-4fe8-8fe8-a9f46daef9e2', 1);
INSERT INTO `question_bank_item` VALUES ('1ffefb57-1617-4ed8-9493-df213c7a6ba9', '2018-01-08 17:39:33', 1, '提高卵母细胞数量能获得更多整倍体胚胎', 3, 0, '2018-01-08 17:39:33', 'ec590cba-1391-4b98-9b79-cf84ab2a7bbb', 1);
INSERT INTO `question_bank_item` VALUES ('20d2d543-9829-4898-88b8-16b62ccb2457', '2018-01-08 17:16:13', 2, 'uFSH制剂是以弱酸性异构体为主', 1, 0, '2018-01-08 17:16:13', 'e088f9fd-0dbc-4681-ad83-ebdf5d4cf089', 1);
INSERT INTO `question_bank_item` VALUES ('23e36b6f-b45a-43b7-a730-5dc82f12777a', '2018-01-08 17:39:33', 1, '第一次注射准备时间短', 1, 0, '2018-01-08 17:39:33', '3a490819-8d87-48d4-b2da-1d3370325723', 1);
INSERT INTO `question_bank_item` VALUES ('245498ea-a14e-40fc-a08f-22c5de0a5160', '2018-01-08 19:45:52', 2, '不需要进行黄体支持强化治疗', 2, 0, '2018-01-08 19:45:52', '1097860e-9878-446c-b960-c25a3ad35c53', 1);
INSERT INTO `question_bank_item` VALUES ('25156840-57a9-473a-970c-db80f7b2c684', '2018-01-08 19:34:01', 2, 'OI/IVI患者', 4, 0, '2018-01-08 19:34:01', '2dcb6c43-c0ee-4e58-a20c-b714ea125353', 1);
INSERT INTO `question_bank_item` VALUES ('259c4b69-e14b-4aad-b2a4-36791f944b90', '2018-01-08 17:43:54', 1, '雪诺同给药器材质柔软安全，不会刮伤阴道', 4, 0, '2018-01-08 17:43:54', 'eeca2022-6f1b-47f9-a36c-d900917e92c4', 1);
INSERT INTO `question_bank_item` VALUES ('2611092c-7c7e-4d6c-9311-79f823b2961d', '2018-01-08 19:34:01', 1, '果纳芬®一次促排，获得更多移植机会', 2, 0, '2018-01-08 19:34:01', '647cff5f-ed3e-466f-88f7-4668b501f443', 1);
INSERT INTO `question_bank_item` VALUES ('268e82a6-79b2-436b-9c0b-2f43f0fe9c6c', '2018-01-08 16:18:17', 2, 'C.稳定IVF质控增加工作负担', 3, 0, '2018-01-08 16:18:17', '5bda84d6-71d6-41e8-b556-d87d347c4ae5', 1);
INSERT INTO `question_bank_item` VALUES ('270e8f33-b8be-4379-820b-15149047f3bc', '2018-01-08 19:34:01', 1, '加强与竞品区分', 3, 0, '2018-01-08 19:34:01', '6852a676-98e2-49ef-b188-a3125af762a5', 1);
INSERT INTO `question_bank_item` VALUES ('2a9b8d7c-2eb1-4ef6-8524-428991841d71', '2018-01-08 16:27:23', 1, 'D.胚胎质量', 4, 0, '2018-01-08 16:27:23', '3ae955dc-b5ef-47df-b51a-cb959ca418bb', 1);
INSERT INTO `question_bank_item` VALUES ('2b85e9d9-5e84-4870-886c-f3a4a01d3501', '2018-01-08 17:23:26', 1, '无排卵(PCOS)且对CC无效的妇女', 1, 0, '2018-01-08 17:23:26', '951974da-1ca0-49d6-bc99-16be87e5b8a3', 1);
INSERT INTO `question_bank_item` VALUES ('2cbba410-cd72-4c21-90df-0ca045f81188', '2018-01-08 19:45:52', 1, '人工周期内膜准备', 2, 0, '2018-01-08 19:45:52', '9955b355-2061-4243-a9d6-b909476d2dcf', 1);
INSERT INTO `question_bank_item` VALUES ('2d55b52d-e125-437a-8bd0-c6ea205e4505', '2018-01-08 19:40:03', 1, '果纳芬®，更多胚胎，更多移植机会', 2, 0, '2018-01-08 19:40:03', '40857b1b-b937-4595-8330-3a2861e38102', 1);
INSERT INTO `question_bank_item` VALUES ('30354636-9fd4-4fb8-b1da-939a41a93893', '2018-01-08 19:45:52', 2, '不需要进行黄体支持', 1, 0, '2018-01-08 19:45:52', '1097860e-9878-446c-b960-c25a3ad35c53', 1);
INSERT INTO `question_bank_item` VALUES ('32ec34ef-674b-4804-bb44-68e6c62b0cd4', '2018-01-08 19:45:52', 1, '以上说法均正确', 4, 0, '2018-01-08 19:45:52', 'f6e0b9bf-87fa-4d3d-aed0-83071b58d17f', 1);
INSERT INTO `question_bank_item` VALUES ('33a2015d-c7e8-4d0a-9923-eb7a960b75d5', '2018-01-08 19:34:01', 1, '果纳芬®一次促排，获得更多卵子', 4, 0, '2018-01-08 19:34:01', '647cff5f-ed3e-466f-88f7-4668b501f443', 1);
INSERT INTO `question_bank_item` VALUES ('3437c43c-4203-43e1-b4e6-be4e275c1d38', '2018-01-08 17:16:13', 2, '果纳芬®是以酸性的异构体为主', 3, 0, '2018-01-08 17:16:13', 'e088f9fd-0dbc-4681-ad83-ebdf5d4cf089', 1);
INSERT INTO `question_bank_item` VALUES ('34777da5-5410-4bd7-a381-136715dd5381', '2018-01-08 17:39:33', 2, '所有患者的COS治疗方案没有很大的差别', 2, 0, '2018-01-08 17:39:33', 'ec590cba-1391-4b98-9b79-cf84ab2a7bbb', 1);
INSERT INTO `question_bank_item` VALUES ('3722f5d8-0ab7-4cea-a690-472ad21fe174', '2018-01-08 19:45:52', 1, '自然周期内膜准备', 1, 0, '2018-01-08 19:45:52', '9955b355-2061-4243-a9d6-b909476d2dcf', 1);
INSERT INTO `question_bank_item` VALUES ('38b6577e-366e-4c76-aba9-ce9d4d139f21', '2018-01-08 16:27:23', 1, 'B.可移植胚胎数', 2, 0, '2018-01-08 16:27:23', '3ae955dc-b5ef-47df-b51a-cb959ca418bb', 1);
INSERT INTO `question_bank_item` VALUES ('38e41c61-9f43-4efa-a1ac-5e3fd408507d', '2018-01-08 16:18:17', 1, 'D.稳定IVF质控，需要选择更稳定精准的Gn', 4, 0, '2018-01-08 16:18:17', '5bda84d6-71d6-41e8-b556-d87d347c4ae5', 1);
INSERT INTO `question_bank_item` VALUES ('3b13529a-8e35-43fe-8215-fdab84bbec8f', '2018-01-08 17:16:13', 2, '卵巢高反应人群体重较高 ', 4, 0, '2018-01-08 17:16:13', '251552ba-b6b4-4dc5-8817-4f614888bff4', 1);
INSERT INTO `question_bank_item` VALUES ('3bd428be-9297-42ba-94b5-01573a18af5a', '2018-01-08 17:23:26', 1, '前次IVF周期卵巢低反应，常规方案获卵≤3个', 3, 0, '2018-01-08 17:23:26', 'f7553cd1-f342-473d-84e0-2e86bfccf2ec', 1);
INSERT INTO `question_bank_item` VALUES ('3c873b4b-9fbc-48df-8a07-e1ddaeae1861', '2018-01-08 17:30:34', 1, '更精准可控', 4, 0, '2018-01-08 17:30:34', 'bdabfa2a-bc38-4fe0-a029-c35ca1106983', 1);
INSERT INTO `question_bank_item` VALUES ('3f0da562-eb4d-404e-9874-6003dd665b12', '2018-01-08 17:16:13', 2, '卵巢高反应人群的获卵数多，因此临床结局也更优', 2, 0, '2018-01-08 17:16:13', '251552ba-b6b4-4dc5-8817-4f614888bff4', 1);
INSERT INTO `question_bank_item` VALUES ('43326d48-32d1-4c29-bf31-658e17d2edc5', '2018-01-08 17:43:54', 2, '12-20小时', 2, 0, '2018-01-08 17:43:54', '577721a2-cab9-488c-b61d-4a71dd3b4453', 1);
INSERT INTO `question_bank_item` VALUES ('43b1fea3-2d0f-4f6f-8794-12db7bb287bf', '2018-01-08 19:34:01', 2, '降价策略', 4, 0, '2018-01-08 19:34:01', '6852a676-98e2-49ef-b188-a3125af762a5', 1);
INSERT INTO `question_bank_item` VALUES ('44883397-6a8c-4d42-8c8d-bfedeaee2b7b', '2018-01-08 19:40:03', 1, '黄体酮缓释凝胶的缓释系统对比阴道胶囊，可以做到一天一次给药', 4, 0, '2018-01-08 19:40:03', '37b6a7e5-8f7c-4fe8-8fe8-a9f46daef9e2', 1);
INSERT INTO `question_bank_item` VALUES ('4568cf3f-8386-40a8-ae94-b52912877fe3', '2018-01-08 19:34:01', 2, '晚上', 2, 0, '2018-01-08 19:34:01', '05f76541-b307-4a91-a535-1cfc351365a8', 1);
INSERT INTO `question_bank_item` VALUES ('46a9ef4e-a4ab-4a5a-aa01-130c1dc2803b', '2018-01-08 17:43:54', 1, '使用前需要捏住给药器粗端，用力甩3-4次', 1, 0, '2018-01-08 17:43:54', 'eeca2022-6f1b-47f9-a36c-d900917e92c4', 1);
INSERT INTO `question_bank_item` VALUES ('4aa12c9d-7ece-48ae-82f7-f97c99f2caef', '2018-01-08 17:30:34', 1, '更高效能', 3, 0, '2018-01-08 17:30:34', 'bdabfa2a-bc38-4fe0-a029-c35ca1106983', 1);
INSERT INTO `question_bank_item` VALUES ('4d20f27c-7ecf-442b-a74f-910bb598b73d', '2018-01-08 16:18:17', 1, 'A.稳定IVF质控持续改善成功率', 1, 0, '2018-01-08 16:18:17', '5bda84d6-71d6-41e8-b556-d87d347c4ae5', 1);
INSERT INTO `question_bank_item` VALUES ('4e986627-fc00-4690-9148-f8fdf050f052', '2018-01-08 17:30:34', 1, '剂量调控简易', 4, 0, '2018-01-08 17:30:34', '029e3e2d-6747-418f-b04b-a065ce3583ca', 1);
INSERT INTO `question_bank_item` VALUES ('4ebdb415-ebb5-49cc-bc6b-dd5ff7dffde6', '2018-01-08 17:23:26', 2, '以上都不是', 4, 0, '2018-01-08 17:23:26', '951974da-1ca0-49d6-bc99-16be87e5b8a3', 1);
INSERT INTO `question_bank_item` VALUES ('52a003fb-4e69-4aa0-b238-c7b71b02ea58', '2018-01-08 17:43:54', 2, '换成肌注黄体酮', 2, 0, '2018-01-08 17:43:54', 'ba71ff72-d31c-4b3c-b83d-eea85082626c', 1);
INSERT INTO `question_bank_item` VALUES ('54403c3e-0bb6-4cb2-ae00-9b9274bdee9f', '2018-01-08 17:16:13', 1, '果纳芬®是以弱酸性的异构体为主', 2, 0, '2018-01-08 17:16:13', 'e088f9fd-0dbc-4681-ad83-ebdf5d4cf089', 1);
INSERT INTO `question_bank_item` VALUES ('551d5dfd-9fb8-448a-97e9-950f04245217', '2018-01-08 17:45:38', 2, '卵泡期', 1, 0, '2018-01-08 17:45:38', 'db1b73be-6702-4f2c-99b2-7a84d620e3f0', 1);
INSERT INTO `question_bank_item` VALUES ('58eb1c1a-e5d6-46eb-b3e5-0e1c07371e6d', '2018-01-08 17:16:13', 2, 'Gn用量', 1, 0, '2018-01-08 17:16:13', 'aa2ab2ef-677d-4e32-bd14-02321e7d050b', 1);
INSERT INTO `question_bank_item` VALUES ('5b2fd2ff-1c82-4470-9bc8-fc94cbafbcc7', '2018-01-08 15:53:04', 2, 'B.±3.8%', 2, 0, '2018-01-08 15:53:04', '8502d1f3-1898-44b7-8178-3c7b5b50925b', 1);
INSERT INTO `question_bank_item` VALUES ('5ba63e8a-92e8-4b90-b71e-363247f9a893', '2018-01-08 15:53:04', 2, 'B.获得持续妊娠', 2, 0, '2018-01-08 15:53:04', '45746f49-e7eb-4374-9218-de6407a82146', 1);
INSERT INTO `question_bank_item` VALUES ('5c79cab6-c661-47db-b777-a2fb7c63962f', '2018-01-08 17:23:26', 1, '累积活产率', 4, 0, '2018-01-08 17:23:26', '6a56e141-0c1f-4362-bf32-f3a66a05e861', 1);
INSERT INTO `question_bank_item` VALUES ('5c9b75f7-054c-4c44-bd10-cc001b9c8764', '2018-01-08 17:23:26', 2, '12 IU', 2, 0, '2018-01-08 17:23:26', '74bfd8cc-0fef-445d-b0fa-873499c2cc2e', 1);
INSERT INTO `question_bank_item` VALUES ('5de70e61-666a-41e9-8ca4-31c835823078', '2018-01-08 17:23:26', 2, '70 IU', 1, 0, '2018-01-08 17:23:26', 'e5c5414b-db67-4c3a-a4d8-d25230c6bf87', 1);
INSERT INTO `question_bank_item` VALUES ('5dfc7387-807d-4612-9195-5d5b4baccc3c', '2018-01-08 15:53:04', 1, 'A.±3.6%', 1, 0, '2018-01-08 15:53:04', '8502d1f3-1898-44b7-8178-3c7b5b50925b', 1);
INSERT INTO `question_bank_item` VALUES ('5e69cbcf-90c7-4c93-a45a-567564c8edf6', '2018-01-08 19:34:01', 2, '果纳芬®带来更多治疗天数和更多Gn用量', 3, 0, '2018-01-08 19:34:01', 'bda6f097-fbdc-4d95-b23d-2fab57331dcc', 1);
INSERT INTO `question_bank_item` VALUES ('5eca0cc2-2bea-41e4-b282-b7b930e715be', '2018-01-08 17:23:26', 1, 'GnRH激动剂长方案', 2, 0, '2018-01-08 17:23:26', '2e782273-6c37-4af7-b008-d42866d36371', 1);
INSERT INTO `question_bank_item` VALUES ('5f1fa733-259c-43bf-979b-638994a8a9d7', '2018-01-08 19:34:01', 2, '任何时候', 4, 0, '2018-01-08 19:34:01', '05f76541-b307-4a91-a535-1cfc351365a8', 1);
INSERT INTO `question_bank_item` VALUES ('6268f83e-dde0-488a-81d4-30885b11bae0', '2018-01-08 15:53:04', 2, 'D.获得妊娠', 4, 0, '2018-01-08 15:53:04', '45746f49-e7eb-4374-9218-de6407a82146', 1);
INSERT INTO `question_bank_item` VALUES ('62ca62ce-c154-4c7a-90f2-6a09eecb05ee', '2018-01-08 15:53:04', 2, 'D.±4.2%', 4, 0, '2018-01-08 15:53:04', '8502d1f3-1898-44b7-8178-3c7b5b50925b', 1);
INSERT INTO `question_bank_item` VALUES ('65b9527a-c0e3-4c3e-8cc8-ecc91de55e5e', '2018-01-08 19:45:52', 1, '需要进行黄体支持强化治疗', 3, 0, '2018-01-08 19:45:52', '1097860e-9878-446c-b960-c25a3ad35c53', 1);
INSERT INTO `question_bank_item` VALUES ('662b9f01-6682-4d17-8d2c-fa87978326f8', '2018-01-08 17:16:13', 1, '减量hCG扳机和GnRH激动剂扳机可降低OHSS风险', 2, 0, '2018-01-08 17:16:13', '0f83d7c2-f025-4bc5-bfd3-f2acc8a91502', 1);
INSERT INTO `question_bank_item` VALUES ('66f7f1e7-c31a-4311-97b7-ad933ee402ea', '2018-01-08 17:43:54', 1, '低促性腺激素性性功能减退症(HH)', 1, 0, '2018-01-08 17:43:54', '05b1db14-2cee-40d2-930a-2e9813ac763f', 1);
INSERT INTO `question_bank_item` VALUES ('6ccbac44-ea02-40fb-a17e-e3f24f630088', '2018-01-08 19:34:01', 1, 'FET人工周期患者', 3, 0, '2018-01-08 19:34:01', '2dcb6c43-c0ee-4e58-a20c-b714ea125353', 1);
INSERT INTO `question_bank_item` VALUES ('6ed57a18-2ac8-41d2-aba0-612b384fb7f4', '2018-01-08 19:40:03', 1, '果纳芬®，更多移植机会，更高抱婴率', 3, 0, '2018-01-08 19:40:03', '40857b1b-b937-4595-8330-3a2861e38102', 1);
INSERT INTO `question_bank_item` VALUES ('6f226839-f47b-4dda-9007-3fee4ebdee5d', '2018-01-08 17:30:34', 1, '无残余LH活性', 2, 0, '2018-01-08 17:30:34', '029e3e2d-6747-418f-b04b-a065ce3583ca', 1);
INSERT INTO `question_bank_item` VALUES ('7083b42e-fac4-44aa-b894-7182ae8bbdc7', '2018-01-08 17:16:13', 1, '刺激天数', 2, 0, '2018-01-08 17:16:13', '2c5df3ae-58c6-4532-8cb6-dd8bc9f42663', 1);
INSERT INTO `question_bank_item` VALUES ('7088ed01-178e-4f44-a65b-044a4cff463e', '2018-01-08 17:43:54', 2, '10-12小时', 4, 0, '2018-01-08 17:43:54', '2ebf9f9b-feb5-498a-bf66-3a938bed32e3', 1);
INSERT INTO `question_bank_item` VALUES ('714f368d-3e94-40d6-b0d4-f86a3d1a74b3', '2018-01-08 17:16:13', 2, '减量hCG扳机和GnRH激动剂扳机可增加OHSS风险', 4, 0, '2018-01-08 17:16:13', '0f83d7c2-f025-4bc5-bfd3-f2acc8a91502', 1);
INSERT INTO `question_bank_item` VALUES ('738ed2c3-4aa9-40bf-ac7d-abe8ad038657', '2018-01-08 19:34:01', 1, 'FET自然周期患者', 2, 0, '2018-01-08 19:34:01', '2dcb6c43-c0ee-4e58-a20c-b714ea125353', 1);
INSERT INTO `question_bank_item` VALUES ('743101dc-ba60-4b02-8c9c-0032d2bab94a', '2018-01-08 17:43:54', 2, '换成口服黄体酮', 4, 0, '2018-01-08 17:43:54', 'ba71ff72-d31c-4b3c-b83d-eea85082626c', 1);
INSERT INTO `question_bank_item` VALUES ('76da6114-4d78-4f65-97ba-078be7436b1c', '2018-01-08 17:16:13', 1, '卵巢高反应人群一般比较年轻', 3, 0, '2018-01-08 17:16:13', '251552ba-b6b4-4dc5-8817-4f614888bff4', 1);
INSERT INTO `question_bank_item` VALUES ('76ea91f8-f58b-47fe-8be0-53f883fc3ab7', '2018-01-08 19:40:03', 2, '累积妊娠率随获卵数的增加而降低', 4, 0, '2018-01-08 19:40:03', '090b2a6c-77ff-4f1e-9326-e13922cf3140', 1);
INSERT INTO `question_bank_item` VALUES ('77677ee4-ddc0-4a11-905d-993c2787b605', '2018-01-08 16:18:17', 1, 'B.稳定IVF质控有助于维持稳定的成功率', 2, 0, '2018-01-08 16:18:17', '5bda84d6-71d6-41e8-b556-d87d347c4ae5', 1);
INSERT INTO `question_bank_item` VALUES ('78729226-1404-4cf7-b708-9484d8a0a8e5', '2018-01-08 16:40:32', 2, '微刺激方案', 2, 0, '2018-01-08 16:40:32', '587da604-f054-450b-891c-de3816b6c38e', 1);
INSERT INTO `question_bank_item` VALUES ('7a246ddb-cbdb-40ff-82a1-9fdf47a0351a', '2018-01-08 16:27:23', 1, 'A.获卵数', 1, 0, '2018-01-08 16:27:23', '3ae955dc-b5ef-47df-b51a-cb959ca418bb', 1);
INSERT INTO `question_bank_item` VALUES ('7ac4e374-2f76-45ea-9daf-174bf2167e80', '2018-01-08 17:16:13', 2, '减量hCG扳机和GnRH拮抗剂扳机可降低OHSS风险', 3, 0, '2018-01-08 17:16:13', '0f83d7c2-f025-4bc5-bfd3-f2acc8a91502', 1);
INSERT INTO `question_bank_item` VALUES ('7afbf2c9-3087-4c1b-ba8c-3ab79e4c29e8', '2018-01-08 17:30:34', 1, '高龄患者添加LH，提高活产率', 3, 0, '2018-01-08 17:30:34', '1da69100-4d0d-4078-9aa8-0aa4a7f664a6', 1);
INSERT INTO `question_bank_item` VALUES ('7c67c4ae-cbe5-4548-b8c9-944d5c81680e', '2018-01-08 19:45:52', 1, '孕妇及哺乳期妇女', 1, 0, '2018-01-08 19:45:52', '5e0f4031-73e7-496e-b652-c4060ad76160', 1);
INSERT INTO `question_bank_item` VALUES ('7e58e60d-13e2-4a65-a457-5dd75ff69a8a', '2018-01-08 17:23:26', 1, '合适数量获卵', 1, 0, '2018-01-08 17:23:26', '6a56e141-0c1f-4362-bf32-f3a66a05e861', 1);
INSERT INTO `question_bank_item` VALUES ('81682fe3-86b3-4f96-9c31-9585af2e3b32', '2018-01-08 17:11:07', 1, '国产rFSH不是果纳芬®的仿制品也不是生物类似物', 4, 0, '2018-01-08 17:11:07', '2cb82d7e-9ffa-4dbf-8f53-b7798d7d6d85', 1);
INSERT INTO `question_bank_item` VALUES ('81fed1c3-aad8-46e1-9ef5-083ac1ce48f8', '2018-01-08 19:34:01', 1, '新鲜周期患者', 1, 0, '2018-01-08 19:34:01', '2dcb6c43-c0ee-4e58-a20c-b714ea125353', 1);
INSERT INTO `question_bank_item` VALUES ('878ccf1d-a87c-40b6-bf31-a6c594cd6b1d', '2018-01-08 19:40:03', 2, '果纳芬®，更多刺激天数及Gn用量', 4, 0, '2018-01-08 19:40:03', '40857b1b-b937-4595-8330-3a2861e38102', 1);
INSERT INTO `question_bank_item` VALUES ('89bebbcb-1b91-41f0-9809-888a62a58c3a', '2018-01-08 19:40:03', 1, '孕激素', 2, 0, '2018-01-08 19:40:03', '573e0536-e282-4ad7-9c94-6b7ba1282082', 1);
INSERT INTO `question_bank_item` VALUES ('8a8095c6-39ec-4d3f-bde9-45ae9d420acc', '2018-01-08 19:40:03', 1, '累积活产率随获卵数的增加而提高', 2, 0, '2018-01-08 19:40:03', '090b2a6c-77ff-4f1e-9326-e13922cf3140', 1);
INSERT INTO `question_bank_item` VALUES ('8b5a0bcf-55e7-4d89-8cfe-63a0f277f553', '2018-01-08 17:16:13', 1, '刺激天数', 2, 0, '2018-01-08 17:16:13', 'aa2ab2ef-677d-4e32-bd14-02321e7d050b', 1);
INSERT INTO `question_bank_item` VALUES ('8bbe9c2d-9560-4b0c-b70c-f5acf778e041', '2018-01-08 19:45:52', 2, '最理想的用法是间隔24小时使用', 3, 0, '2018-01-08 19:45:52', 'f6e0b9bf-87fa-4d3d-aed0-83071b58d17f', 1);
INSERT INTO `question_bank_item` VALUES ('8cf1fc6e-03da-4cef-893b-0ba60c9e9d90', '2018-01-08 17:23:26', 1, '减少治疗天数及FSH总剂量', 4, 0, '2018-01-08 17:23:26', '865305e1-7498-4ed0-956f-31807ad79c60', 1);
INSERT INTO `question_bank_item` VALUES ('9046dd56-931c-428e-9326-61015bdfe4c8', '2018-01-08 19:40:03', 2, '果纳芬®与来自尿源提取的uFSH结构一样，活性一样', 4, 0, '2018-01-08 19:40:03', '29fc7f00-6f9f-43d0-9ed0-2feb1f7b9a6c', 1);
INSERT INTO `question_bank_item` VALUES ('90764080-56b4-4cbf-bef9-20cf48f8c5da', '2018-01-08 19:45:52', 1, '25℃室温保存', 1, 0, '2018-01-08 19:45:52', '17cc5490-a1d0-4fd5-9656-23f261220ca7', 1);
INSERT INTO `question_bank_item` VALUES ('91a8fadd-c3b4-4d9a-ad69-664c5c175108', '2018-01-08 19:34:01', 1, '果纳芬®一次促排，可获得更多抱婴机会', 2, 0, '2018-01-08 19:34:01', 'bda6f097-fbdc-4d95-b23d-2fab57331dcc', 1);
INSERT INTO `question_bank_item` VALUES ('924b0d65-c398-4f28-8dac-cbbde84d0b63', '2018-01-08 17:23:26', 1, '卵巢储备下降（ AFC＜5～7 个或 AMH＜0.5～1.1ng/mL） ', 4, 0, '2018-01-08 17:23:26', 'f7553cd1-f342-473d-84e0-2e86bfccf2ec', 1);
INSERT INTO `question_bank_item` VALUES ('997a80a2-76ac-4d3d-8a53-2f642f2cc511', '2018-01-08 17:16:13', 1, '活产率', 4, 0, '2018-01-08 17:16:13', '2c5df3ae-58c6-4532-8cb6-dd8bc9f42663', 1);
INSERT INTO `question_bank_item` VALUES ('9a16593c-232d-442a-bcab-43210c69bf2c', '2018-01-08 17:43:54', 1, '经阴道给药后，给药器中会正常残留少量凝胶', 2, 0, '2018-01-08 17:43:54', 'eeca2022-6f1b-47f9-a36c-d900917e92c4', 1);
INSERT INTO `question_bank_item` VALUES ('9b84c5d4-2296-46b7-a41d-14ef2fd3be99', '2018-01-08 17:23:26', 1, '高龄(≥40 岁)或存在卵巢反应不良的其它危险因素', 1, 0, '2018-01-08 17:23:26', 'f7553cd1-f342-473d-84e0-2e86bfccf2ec', 1);
INSERT INTO `question_bank_item` VALUES ('9bed322b-74fa-48da-a887-593651b95b40', '2018-01-08 17:39:33', 2, '不易学习', 4, 0, '2018-01-08 17:39:33', '3a490819-8d87-48d4-b2da-1d3370325723', 1);
INSERT INTO `question_bank_item` VALUES ('9c49e632-9324-4256-a977-bfa4ef38724b', '2018-01-08 19:34:01', 1, '果纳芬®能够减少多次促排的时间和花费', 4, 0, '2018-01-08 19:34:01', 'bda6f097-fbdc-4d95-b23d-2fab57331dcc', 1);
INSERT INTO `question_bank_item` VALUES ('9c8bbe4f-a4d5-4504-84e6-d6c0dc21b367', '2018-01-08 17:30:34', 1, 'NOR推荐方案为激动剂长方案或拮抗剂方案', 4, 0, '2018-01-08 17:30:34', 'c8b6692c-3654-4dd3-8edc-cf46f1880c60', 1);
INSERT INTO `question_bank_item` VALUES ('9d8104be-594b-4ac0-a8be-15cc3f86d611', '2018-01-08 17:43:54', 1, '少量点滴出血可以继续使用雪诺同，直到HCG检测日，HCG阳性则继续使用至孕12周', 3, 0, '2018-01-08 17:43:54', 'ba71ff72-d31c-4b3c-b83d-eea85082626c', 1);
INSERT INTO `question_bank_item` VALUES ('9e23ebf0-7e2d-42af-961e-0a3f4f40ec5a', '2018-01-08 19:34:01', 1, '应用果纳芬®能够获得更多第3天胚胎以供新鲜或冷冻移植，从而增加了累积妊娠和活产的机会', 1, 0, '2018-01-08 19:34:01', 'bda6f097-fbdc-4d95-b23d-2fab57331dcc', 1);
INSERT INTO `question_bank_item` VALUES ('9f51e434-92ba-480b-af7b-1b6b06e59a5b', '2018-01-08 19:40:03', 2, 'LH水平应该低于阈值', 1, 0, '2018-01-08 19:40:03', '4cbed08b-f802-4374-90cc-9cafec6bb65a', 1);
INSERT INTO `question_bank_item` VALUES ('9f8ca5d3-32cc-4bb9-8e06-a54aac14e8aa', '2018-01-08 17:43:54', 1, '低反应', 2, 0, '2018-01-08 17:43:54', '05b1db14-2cee-40d2-930a-2e9813ac763f', 1);
INSERT INTO `question_bank_item` VALUES ('9fdc8b8c-9ac4-47a5-ab40-affb2b229e76', '2018-01-08 19:40:03', 2, '累积活产率与获卵数并无相关关系', 3, 0, '2018-01-08 19:40:03', '090b2a6c-77ff-4f1e-9326-e13922cf3140', 1);
INSERT INTO `question_bank_item` VALUES ('9ff93dd0-7a14-487a-a4e9-6f4d3375a134', '2018-01-08 16:40:32', 1, 'GnRH拮抗剂方案', 4, 0, '2018-01-08 16:40:32', '587da604-f054-450b-891c-de3816b6c38e', 1);
INSERT INTO `question_bank_item` VALUES ('a2e17f9d-99d4-45e1-887d-e2413bc0a06a', '2018-01-08 19:34:01', 2, '测不出', 4, 0, '2018-01-08 19:34:01', '782ce4a2-f3dd-4f0d-9450-0bd62f33755f', 1);
INSERT INTO `question_bank_item` VALUES ('a3d3dccd-510e-4007-9a3c-056fc847e56c', '2018-01-08 19:45:52', 2, '冷冻保存', 3, 0, '2018-01-08 19:45:52', '17cc5490-a1d0-4fd5-9656-23f261220ca7', 1);
INSERT INTO `question_bank_item` VALUES ('a693384a-2094-4269-b174-70b118f4ec1a', '2018-01-08 19:45:52', 2, '5℃下冷藏保存', 2, 0, '2018-01-08 19:45:52', '17cc5490-a1d0-4fd5-9656-23f261220ca7', 1);
INSERT INTO `question_bank_item` VALUES ('aab45d6d-8e03-4669-8e43-452c39195d54', '2018-01-08 19:40:03', 1, '果纳芬®，一次刺激多获卵，更多胚胎', 1, 0, '2018-01-08 19:40:03', '40857b1b-b937-4595-8330-3a2861e38102', 1);
INSERT INTO `question_bank_item` VALUES ('aabdee40-4dcd-4edd-8317-3462f01a1df7', '2018-01-08 17:39:33', 1, '每日注射准备时间短', 2, 0, '2018-01-08 17:39:33', '3a490819-8d87-48d4-b2da-1d3370325723', 1);
INSERT INTO `question_bank_item` VALUES ('ab253031-5790-4da9-8d3c-c776ea960af1', '2018-01-08 17:23:26', 2, '前次IVF周期卵巢低反应，常规方案获卵≤4个', 2, 0, '2018-01-08 17:23:26', 'f7553cd1-f342-473d-84e0-2e86bfccf2ec', 1);
INSERT INTO `question_bank_item` VALUES ('ac11e55e-49b7-4e2c-8d81-8a11c3de5dd1', '2018-01-08 19:40:03', 1, '口服地屈孕酮或口服黄体酮，对血清孕酮浓度贡献非常低', 3, 0, '2018-01-08 19:40:03', '37b6a7e5-8f7c-4fe8-8fe8-a9f46daef9e2', 1);
INSERT INTO `question_bank_item` VALUES ('ac7147a2-2739-433a-9433-eba2d6a66b9d', '2018-01-08 17:23:26', 1, '75 IU', 2, 0, '2018-01-08 17:23:26', 'e5c5414b-db67-4c3a-a4d8-d25230c6bf87', 1);
INSERT INTO `question_bank_item` VALUES ('ade06615-6e0c-49ff-a657-455a0094267e', '2018-01-08 19:45:52', 2, '若忘记使用本品，应立即与医生联系', 2, 0, '2018-01-08 19:45:52', 'f6e0b9bf-87fa-4d3d-aed0-83071b58d17f', 1);
INSERT INTO `question_bank_item` VALUES ('b0b2032d-0147-4d58-a0c3-b42f95ab69ab', '2018-01-08 17:23:26', 1, '更恒定的卵巢反应', 2, 0, '2018-01-08 17:23:26', '865305e1-7498-4ed0-956f-31807ad79c60', 1);
INSERT INTO `question_bank_item` VALUES ('b0b61a4b-4d84-4044-9743-ccd00d4e3ed0', '2018-01-08 19:45:52', 2, '其他三项都对', 4, 0, '2018-01-08 19:45:52', '17cc5490-a1d0-4fd5-9656-23f261220ca7', 1);
INSERT INTO `question_bank_item` VALUES ('b0c9080d-e774-478e-9a53-21e1eb9bafc3', '2018-01-08 17:30:34', 2, '高龄患者添加LH，无明显获益', 4, 0, '2018-01-08 17:30:34', '1da69100-4d0d-4078-9aa8-0aa4a7f664a6', 1);
INSERT INTO `question_bank_item` VALUES ('b20421f1-64dc-4ba5-ae6a-9055cb4266d1', '2018-01-08 17:23:26', 1, '最大化新鲜周期活产率', 2, 0, '2018-01-08 17:23:26', '6a56e141-0c1f-4362-bf32-f3a66a05e861', 1);
INSERT INTO `question_bank_item` VALUES ('b2556f36-7dd3-478a-bc6c-75be3598138e', '2018-01-08 19:40:03', 1, '阴道黄体酮具有子宫首过效应，靶向给药，避免了全身高血清孕酮浓度引起的不良反应', 2, 0, '2018-01-08 19:40:03', '37b6a7e5-8f7c-4fe8-8fe8-a9f46daef9e2', 1);
INSERT INTO `question_bank_item` VALUES ('b5025bf9-1fe8-4191-94d6-31661e1ff605', '2018-01-08 17:23:26', 2, '14.5 IU', 4, 0, '2018-01-08 17:23:26', '74bfd8cc-0fef-445d-b0fa-873499c2cc2e', 1);
INSERT INTO `question_bank_item` VALUES ('b753684d-06f7-402b-9ad7-0bb899510829', '2018-01-08 19:40:03', 2, '雌激素', 1, 0, '2018-01-08 19:40:03', '573e0536-e282-4ad7-9c94-6b7ba1282082', 1);
INSERT INTO `question_bank_item` VALUES ('b88a6166-a961-43df-8f64-a02e9faba63f', '2018-01-08 19:45:52', 1, '中度至重度肝肾功能损伤者', 3, 0, '2018-01-08 19:45:52', '5e0f4031-73e7-496e-b652-c4060ad76160', 1);
INSERT INTO `question_bank_item` VALUES ('ba6e4bd7-1618-475a-bc2d-3107785885f0', '2018-01-08 17:43:54', 2, '6-12小时', 1, 0, '2018-01-08 17:43:54', '577721a2-cab9-488c-b61d-4a71dd3b4453', 1);
INSERT INTO `question_bank_item` VALUES ('bb6e229f-cf00-486e-bec0-9443db1c3ef9', '2018-01-08 17:23:26', 2, '耐受性明显劣于uFSH', 1, 0, '2018-01-08 17:23:26', '865305e1-7498-4ed0-956f-31807ad79c60', 1);
INSERT INTO `question_bank_item` VALUES ('bbd83861-1900-4338-b520-02e667d79870', '2018-01-08 15:53:04', 1, 'C.±1.6%', 3, 0, '2018-01-08 15:53:04', '024277d2-8b12-4942-ae88-f4a2c6249b60', 1);
INSERT INTO `question_bank_item` VALUES ('bc277876-701d-4b34-82ac-8062a509c10a', '2018-01-08 19:40:03', 2, '人绒毛膜促性腺激素', 4, 0, '2018-01-08 19:40:03', '573e0536-e282-4ad7-9c94-6b7ba1282082', 1);
INSERT INTO `question_bank_item` VALUES ('be1e410e-02bb-435b-83c4-bd324c5b67b6', '2018-01-08 17:16:13', 2, '增量hCG扳机和GnRH激动剂扳机可降低OHSS风险 ', 1, 0, '2018-01-08 17:16:13', '0f83d7c2-f025-4bc5-bfd3-f2acc8a91502', 1);
INSERT INTO `question_bank_item` VALUES ('bf7b28f2-41d3-42e1-9d15-d158c667c9ce', '2018-01-08 15:53:04', 1, 'C.抱婴回家', 3, 0, '2018-01-08 15:53:04', '45746f49-e7eb-4374-9218-de6407a82146', 1);
INSERT INTO `question_bank_item` VALUES ('c30645e0-5dc1-4b02-9f4b-e2af54418e71', '2018-01-08 19:40:03', 2, '累积妊娠率随移植机会的增加先增加，后降低', 1, 0, '2018-01-08 19:40:03', '090b2a6c-77ff-4f1e-9326-e13922cf3140', 1);
INSERT INTO `question_bank_item` VALUES ('c32a43f9-250a-482c-9c88-963c52c9a235', '2018-01-08 19:34:01', 2, '中午', 3, 0, '2018-01-08 19:34:01', '05f76541-b307-4a91-a535-1cfc351365a8', 1);
INSERT INTO `question_bank_item` VALUES ('c364b146-425f-48ca-853c-1ae571a640c4', '2018-01-08 17:30:34', 1, 'NOR促排目标为10-15个卵母细胞', 2, 0, '2018-01-08 17:30:34', 'c8b6692c-3654-4dd3-8edc-cf46f1880c60', 1);
INSERT INTO `question_bank_item` VALUES ('c880a7ec-2e5b-47b2-b745-697c75698ad7', '2018-01-08 17:23:26', 1, '更好地控制卵巢反应，减少周期取消', 3, 0, '2018-01-08 17:23:26', '865305e1-7498-4ed0-956f-31807ad79c60', 1);
INSERT INTO `question_bank_item` VALUES ('c881fe26-9741-4296-a9bd-f5a1672dab81', '2018-01-08 17:16:13', 1, '卵巢高反应人群OHSS发生率增加', 1, 0, '2018-01-08 17:16:13', '251552ba-b6b4-4dc5-8817-4f614888bff4', 1);
INSERT INTO `question_bank_item` VALUES ('c8cab47e-f760-4433-8a43-282fef7f5354', '2018-01-08 17:30:34', 1, '批次间高度一致性', 3, 0, '2018-01-08 17:30:34', '029e3e2d-6747-418f-b04b-a065ce3583ca', 1);
INSERT INTO `question_bank_item` VALUES ('cce90f62-429f-4eb6-9b35-fd2207e30b16', '2018-01-08 17:23:26', 2, '温和刺激方案', 3, 0, '2018-01-08 17:23:26', '2e782273-6c37-4af7-b008-d42866d36371', 1);
INSERT INTO `question_bank_item` VALUES ('ced5596b-b356-4887-a39a-b2b6fa2958e0', '2018-01-08 17:16:13', 1, 'uFSH制剂是以酸性异构体为主', 4, 0, '2018-01-08 17:16:13', 'e088f9fd-0dbc-4681-ad83-ebdf5d4cf089', 1);
INSERT INTO `question_bank_item` VALUES ('d0ffc53d-f723-43cf-9f54-f24966d10cc7', '2018-01-08 17:43:54', 2, '7-8小时', 1, 0, '2018-01-08 17:43:54', '2ebf9f9b-feb5-498a-bf66-3a938bed32e3', 1);
INSERT INTO `question_bank_item` VALUES ('d1d37b05-873e-403d-86f9-af90fe8cd251', '2018-01-08 15:53:04', 2, 'C.±4.0%', 3, 0, '2018-01-08 15:53:04', '8502d1f3-1898-44b7-8178-3c7b5b50925b', 1);
INSERT INTO `question_bank_item` VALUES ('d2ccf595-7011-41be-a7e0-767eba2e5ab2', '2018-01-08 17:11:07', 2, '200IU', 2, 0, '2018-01-08 17:11:07', '9f6e3e8c-d396-4f4e-af50-1b9c9d48c970', 1);
INSERT INTO `question_bank_item` VALUES ('d307c493-72fa-4d89-a4bf-a1fae7575113', '2018-01-08 17:43:54', 1, '4-5小时', 3, 0, '2018-01-08 17:43:54', '2ebf9f9b-feb5-498a-bf66-3a938bed32e3', 1);
INSERT INTO `question_bank_item` VALUES ('d4c01902-5a14-4977-8926-64127e75a831', '2018-01-08 16:27:23', 1, 'C.患者年龄', 3, 0, '2018-01-08 16:27:23', '3ae955dc-b5ef-47df-b51a-cb959ca418bb', 1);
INSERT INTO `question_bank_item` VALUES ('d684fc39-0518-4080-bf5d-ee31a425d1af', '2018-01-08 17:39:33', 1, '累积活产率随获卵数增加而显著增高', 1, 0, '2018-01-08 17:39:33', 'ec590cba-1391-4b98-9b79-cf84ab2a7bbb', 1);
INSERT INTO `question_bank_item` VALUES ('dbfc46c1-7473-4e39-91a3-d03b95e5fae4', '2018-01-08 15:53:04', 2, 'A.胚胎成功着床', 1, 0, '2018-01-08 15:53:04', '45746f49-e7eb-4374-9218-de6407a82146', 1);
INSERT INTO `question_bank_item` VALUES ('dc2f1a0b-d28e-4259-ac19-a04cb5b1612a', '2018-01-08 17:43:54', 2, '3-6小时', 4, 0, '2018-01-08 17:43:54', '577721a2-cab9-488c-b61d-4a71dd3b4453', 1);
INSERT INTO `question_bank_item` VALUES ('dcac7dc3-575b-416d-826b-1c5572209cd7', '2018-01-08 17:30:34', 2, 'NOR促排目标为5-10个卵母细胞', 1, 0, '2018-01-08 17:30:34', 'c8b6692c-3654-4dd3-8edc-cf46f1880c60', 1);
INSERT INTO `question_bank_item` VALUES ('dd853b3b-ca8c-42be-9d21-2e28ee4bac81', '2018-01-08 17:45:38', 2, '排卵期', 3, 0, '2018-01-08 17:45:38', 'db1b73be-6702-4f2c-99b2-7a84d620e3f0', 1);
INSERT INTO `question_bank_item` VALUES ('df9d2ee6-eb26-4025-9862-32e54659006a', '2018-01-08 19:34:01', 1, '14.87ng/ml左右', 1, 0, '2018-01-08 19:34:01', '782ce4a2-f3dd-4f0d-9450-0bd62f33755f', 1);
INSERT INTO `question_bank_item` VALUES ('dff30c54-c692-4a83-8968-10020c3bf766', '2018-01-08 17:43:54', 1, '慢反应', 3, 0, '2018-01-08 17:43:54', '05b1db14-2cee-40d2-930a-2e9813ac763f', 1);
INSERT INTO `question_bank_item` VALUES ('dff8d418-fc5b-46e7-9849-370d8b35b330', '2018-01-08 17:16:13', 1, 'Gn用量', 1, 0, '2018-01-08 17:16:13', '2c5df3ae-58c6-4532-8cb6-dd8bc9f42663', 1);
INSERT INTO `question_bank_item` VALUES ('e0370c7d-d5a8-4724-8417-f631c3159ad4', '2018-01-08 17:23:26', 2, '125 IU', 4, 0, '2018-01-08 17:23:26', 'e5c5414b-db67-4c3a-a4d8-d25230c6bf87', 1);
INSERT INTO `question_bank_item` VALUES ('e1380c33-e8be-4f08-9e97-f6e2d3502c31', '2018-01-08 17:11:07', 2, '国产rFSH属于重组FSH，产品批次间差异跟果纳芬®一样', 3, 0, '2018-01-08 17:11:07', '2cb82d7e-9ffa-4dbf-8f53-b7798d7d6d85', 1);
INSERT INTO `question_bank_item` VALUES ('e26a7a2b-4954-4905-b4c0-126098285773', '2018-01-08 17:23:26', 2, '10.5 IU', 1, 0, '2018-01-08 17:23:26', '74bfd8cc-0fef-445d-b0fa-873499c2cc2e', 1);
INSERT INTO `question_bank_item` VALUES ('e45aee5a-a925-4ffc-b6c2-6a1a046f640e', '2018-01-08 19:34:01', 1, '强化雪诺同基础黄体支持用药概念', 2, 0, '2018-01-08 19:34:01', '6852a676-98e2-49ef-b188-a3125af762a5', 1);
INSERT INTO `question_bank_item` VALUES ('e537bc77-dac2-4484-9d1b-13ec2a7ddfed', '2018-01-08 17:30:34', 1, '高龄患者添加LH，提高临床妊娠率', 1, 0, '2018-01-08 17:30:34', '1da69100-4d0d-4078-9aa8-0aa4a7f664a6', 1);
INSERT INTO `question_bank_item` VALUES ('e5be6365-6314-48ee-a10f-5152b3f13cc6', '2018-01-08 17:11:07', 2, '国产rFSH是果纳芬®生物类似物', 2, 0, '2018-01-08 17:11:07', '2cb82d7e-9ffa-4dbf-8f53-b7798d7d6d85', 1);
INSERT INTO `question_bank_item` VALUES ('e7aa80ad-7ed8-49bd-8f81-bc9b7fdd034b', '2018-01-08 19:40:03', 1, '果纳芬®弱酸性异构体与排卵期天然FSH一致，比酸性异构体uFSH生物效能更高', 3, 0, '2018-01-08 19:40:03', '29fc7f00-6f9f-43d0-9ed0-2feb1f7b9a6c', 1);
INSERT INTO `question_bank_item` VALUES ('e8126d72-8432-4b91-a896-b2fcc89420df', '2018-01-08 19:40:03', 2, '雄激素', 3, 0, '2018-01-08 19:40:03', '573e0536-e282-4ad7-9c94-6b7ba1282082', 1);
INSERT INTO `question_bank_item` VALUES ('e9a9334e-e62e-4ba5-8b2a-2d4c400de941', '2018-01-08 17:23:26', 2, '95 IU', 3, 0, '2018-01-08 17:23:26', 'e5c5414b-db67-4c3a-a4d8-d25230c6bf87', 1);
INSERT INTO `question_bank_item` VALUES ('eb28e54e-c0b6-4085-a863-04a3e54818b9', '2018-01-08 19:40:03', 1, 'LH水平应该超过阈值，但低于LH上限', 2, 0, '2018-01-08 19:40:03', '4cbed08b-f802-4374-90cc-9cafec6bb65a', 1);
INSERT INTO `question_bank_item` VALUES ('ec09471f-ae1f-4923-923d-17cccc513391', '2018-01-08 19:45:52', 1, '绝经期妇女', 2, 0, '2018-01-08 19:45:52', '5e0f4031-73e7-496e-b652-c4060ad76160', 1);
INSERT INTO `question_bank_item` VALUES ('ec4f8522-fdb7-4b93-8de1-b9baf3167c0a', '2018-01-08 17:43:54', 2, '停止使用雪诺同', 1, 0, '2018-01-08 17:43:54', 'ba71ff72-d31c-4b3c-b83d-eea85082626c', 1);
INSERT INTO `question_bank_item` VALUES ('eed4668d-460d-4a25-a9e5-c67bde5cae7e', '2018-01-08 17:45:38', 2, '以上都不是', 4, 0, '2018-01-08 17:45:38', 'db1b73be-6702-4f2c-99b2-7a84d620e3f0', 1);
INSERT INTO `question_bank_item` VALUES ('efac356e-9b59-47ce-8e3f-ef7beb99ab74', '2018-01-08 17:43:54', 1, '在高原地区使用，可以在给药器粗端扁平面刺一个小孔平衡气压', 3, 0, '2018-01-08 17:43:54', 'eeca2022-6f1b-47f9-a36c-d900917e92c4', 1);
INSERT INTO `question_bank_item` VALUES ('f04c07ba-381d-4cc5-a714-fdc9cad257d1', '2018-01-08 17:16:13', 2, '活产率', 4, 0, '2018-01-08 17:16:13', 'aa2ab2ef-677d-4e32-bd14-02321e7d050b', 1);
INSERT INTO `question_bank_item` VALUES ('f2a90de2-ff67-4b92-bdc8-e85ec8bb7311', '2018-01-08 15:53:04', 2, 'A.±1.2%', 1, 0, '2018-01-08 15:53:04', '024277d2-8b12-4942-ae88-f4a2c6249b60', 1);
INSERT INTO `question_bank_item` VALUES ('f2e3679d-6281-4f47-a3c0-5f4668b46802', '2018-01-08 19:40:03', 1, '果纳芬®的α和β亚基全部氨基酸序列与天然hFSH一致', 2, 0, '2018-01-08 19:40:03', '29fc7f00-6f9f-43d0-9ed0-2feb1f7b9a6c', 1);
INSERT INTO `question_bank_item` VALUES ('f4b61f0d-419b-42c6-b28d-ca7e122469de', '2018-01-08 19:34:01', 1, '果纳芬®一次促排，可避免多次促排造成的时间和花费成本', 3, 0, '2018-01-08 19:34:01', '647cff5f-ed3e-466f-88f7-4668b501f443', 1);
INSERT INTO `question_bank_item` VALUES ('f54d3251-2730-42c6-87fd-c9865a81fa6f', '2018-01-08 19:34:01', 2, '果纳芬®一次促排，Gn用量更多', 1, 0, '2018-01-08 19:34:01', '647cff5f-ed3e-466f-88f7-4668b501f443', 1);
INSERT INTO `question_bank_item` VALUES ('f850f526-a6b7-4898-ac96-0df2d73e8fbd', '2018-01-08 17:30:34', 1, '更多获卵', 2, 0, '2018-01-08 17:30:34', 'bdabfa2a-bc38-4fe0-a029-c35ca1106983', 1);
INSERT INTO `question_bank_item` VALUES ('f95d038d-0c08-4fd2-b90f-1febf7231d0a', '2018-01-08 17:43:54', 1, '20-50小时', 3, 0, '2018-01-08 17:43:54', '577721a2-cab9-488c-b61d-4a71dd3b4453', 1);
INSERT INTO `question_bank_item` VALUES ('fa5ed88d-41ef-4d28-953a-9ed06c21018e', '2018-01-08 19:40:03', 2, 'LH水平没有特殊要求', 4, 0, '2018-01-08 19:40:03', '4cbed08b-f802-4374-90cc-9cafec6bb65a', 1);
INSERT INTO `question_bank_item` VALUES ('fa969b33-5040-4e39-afa4-11c9c92ee0a8', '2018-01-08 19:40:03', 1, '果纳芬®利用哺乳动物细胞系作为表达载体，采用最先进的重组技术生产，其纯度非常高', 1, 0, '2018-01-08 19:40:03', '29fc7f00-6f9f-43d0-9ed0-2feb1f7b9a6c', 1);
INSERT INTO `question_bank_item` VALUES ('ff922f43-e781-44ea-848f-5c67df674737', '2018-01-08 17:30:34', 1, '更高累积活产率', 1, 0, '2018-01-08 17:30:34', 'bdabfa2a-bc38-4fe0-a029-c35ca1106983', 1);
COMMIT;

-- ----------------------------
-- Table structure for signin
-- ----------------------------
DROP TABLE IF EXISTS `signin`;
CREATE TABLE `signin` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `signin_day` int(11) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKCA356FA2146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FKCA356FA2146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sys_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_admin_user`;
CREATE TABLE `sys_admin_user` (
  `id` varchar(255) NOT NULL,
  `createtime` varchar(255) DEFAULT NULL,
  `issuperadmin` varchar(255) DEFAULT NULL,
  `loginname` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sys_department
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE `sys_department` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `departmentid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parentid` varchar(255) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_department
-- ----------------------------
BEGIN;
INSERT INTO `sys_department` VALUES ('0083a0d9-3d01-4f6c-87ab-c04e4ad4eb7a', '2018-01-07 18:28:14', '16', 'CEO office', '2', 99994000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('05f822d0-46a1-4f38-b26c-d00aa94dee5a', '2018-01-07 18:28:14', '10', 'Account', '2', 100000000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('3f4ecc5d-2e28-4e59-a345-a53b799c45ca', '2018-01-07 18:28:14', '18', 'CEO office', '3', 99993000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('567bee1a-085b-4f8e-a80d-ee561ee2ed0d', '2018-01-07 18:28:14', '9', 'Medical', '3', 99995000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('5d64239e-a5e0-4fa6-99ce-d18b0e0085cb', '2018-01-07 18:28:14', '14', 'Medical', '2', 99996000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('6f321522-e71f-41c2-b407-7ca939514204', '2018-01-07 18:28:14', '3', '上海', '1', 99999000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('9448e079-f7db-4fa9-b179-ff2b01828937', '2018-01-07 18:28:14', '13', 'Finance', '2', 99997000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('9ec73019-2f01-46ba-8319-ede6fd957ac2', '2018-01-07 18:28:14', '7', 'Digital', '3', 99997000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('9f73905e-c287-49c9-8dd5-80b2df47f3dd', '2018-01-07 18:28:14', '6', 'Creative', '3', 99998000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('a3ff116e-86b7-469e-aa18-0394d1269e93', '2018-01-07 18:28:14', '15', 'Admin', '2', 99995000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('be2e2c69-ce34-4b7a-99fc-722122617b5f', '2018-01-07 18:28:14', '12', 'Digital', '2', 99998000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('c99b17c2-7fa9-44db-b3f3-b037e7c1b235', '2018-01-07 18:28:14', '11', 'Creative', '2', 99999000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('d79f851c-4841-4ed9-802e-65c74c9e8628', '2018-01-07 18:28:14', '17', 'Admin', '3', 99994000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('e1107051-0445-4d25-8089-1e37c43a6a96', '2018-01-07 18:28:14', '8', 'Finance', '3', 99996000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('e7af4846-5ddf-4c87-be85-488ec9eb1b3a', '2018-01-07 18:28:14', '2', '北京', '1', 100000000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('f43e0233-53a4-4a8c-8466-abe60e6ef08f', '2018-01-07 18:28:14', '1', '北京康斯泰克广告有限公司', '0', 100000000, 0, '2018-01-07 18:28:14');
INSERT INTO `sys_department` VALUES ('f5db49a7-358a-49e4-88e7-02f0819d72cd', '2018-01-07 18:28:14', '5', 'Account', '3', 99999000, 0, '2018-01-07 18:28:14');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(255) NOT NULL,
  `all_integral` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `is_admin` bigint(20) DEFAULT NULL,
  `isleader` int(11) DEFAULT NULL,
  `loginname` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `test_status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `use_integral` varchar(255) DEFAULT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `wx_status` bigint(20) DEFAULT NULL,
  `english_name` varchar(255) DEFAULT NULL,
  `schedule` bigint(20) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('0be1af05-39c6-424a-8149-32f3d4dd6879', '0', 'http://p.qlogo.cn/bizmail/mwsibZdrIpbnuaKuwZt0XAicvGFDezUT6sZyxtWyCM1TrDeyBgvnNd7Q/0', '2018-01-10 06:37:07', '', 2, 0, 0, NULL, '13910826145', '杨秋宁', NULL, NULL, '', 0, NULL, 1, '2018-01-11 10:20:56', '0', 'YangQiuNing', 100, NULL, 3, 'L12');
INSERT INTO `sys_user` VALUES ('0e568a49-426a-4c0f-8730-2f3d62828c11', '0', 'http://p.qlogo.cn/bizmail/Cs19U0RmZLOtrVpMzibVLqibKzLwSZGTMn2ib8qovTRE0fPjUXDHYb8HA/0', '2018-01-10 17:27:33', 'yuhao.li@consultech.com.cn', 1, 0, 0, NULL, '15195245866', 'Yuhao Li', NULL, NULL, '', 0, NULL, 1, '2018-03-04 19:45:26', '0', 'LiYuHao', 0, NULL, 0, 'L21');
INSERT INTO `sys_user` VALUES ('384ea627-d64b-4f57-89d5-c8fa083ff43c', '0', 'http://p.qlogo.cn/bizmail/kZhtceXxTpicEA2VxuibdkVhtQrKQENfZsDicUjU6Zhz08wnW0QoUIicQw/0', '2018-01-11 19:22:47', '', 1, 0, 0, NULL, '18912327838', '张浩高', NULL, NULL, '', 0, NULL, 1, '2018-01-11 19:25:19', '0', 'yog', 0, NULL, 3, 'L21');
INSERT INTO `sys_user` VALUES ('5fdb4d70-00bf-4402-b44f-e4eff2821c0b', '0', 'http://p.qlogo.cn/bizmail/7hxSe1leN4iaIVrWCGkC7jlibwzOH84nPRLl7BnxX4EgJeJV752f9smQ/0', '2018-01-10 12:27:05', '', 2, 0, 0, NULL, '13683573393', '张晴', NULL, NULL, '', 0, NULL, 1, '2018-03-07 11:53:46', '0', 'ZhangQing', 0, NULL, 3, 'L32');
INSERT INTO `sys_user` VALUES ('c511ec04-84a3-4686-a9bf-fc29f2dc315a', '0', 'http://p.qlogo.cn/bizmail/fv7yMexI4KJ9l2T4iahCJsnon0yibNjvBJPYvQSNWRmKkKIdRkSyRkWw/0', '2018-01-08 16:11:51', '', 1, 0, 0, NULL, '18601028808', '杨硕', NULL, NULL, '', 0, NULL, 1, '2018-03-07 15:05:34', '0', 'YangShuo', 0, NULL, 3, 'L2');
INSERT INTO `sys_user` VALUES ('manager', '111', 'http://wx.qlogo.cn/mmopen/eX5SicS4qmphbahqUD03sTIqMgU411uIdu2JJ3HwYptUqxdMhNlsWeNfVWXn0t0T4y4bSdLGMXicdPta2t3fcR7hKxv09knYPa/0', NULL, NULL, NULL, 1, NULL, 'manager', NULL, 'sadsmanager', NULL, '5lULSh4A13Taa/axgGb+/g==', NULL, 0, NULL, 1, NULL, '100', 'manager', NULL, NULL, 0, 'L1');
COMMIT;

-- ----------------------------
-- Table structure for user_address
-- ----------------------------
DROP TABLE IF EXISTS `user_address`;
CREATE TABLE `user_address` (
  `id` varchar(255) NOT NULL,
  `area` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK16873380146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK16873380146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_address
-- ----------------------------
BEGIN;
INSERT INTO `user_address` VALUES ('81bde230-72af-4a7b-8283-87972f1d538a', '洛龙区', '洛阳市', '2018-03-08 15:39:32', '傻按时', '17798903668', NULL, '河南省', NULL, 'sasasasa飒飒多', '2018-03-08 15:39:32', 'manager');
COMMIT;

-- ----------------------------
-- Table structure for user_collection
-- ----------------------------
DROP TABLE IF EXISTS `user_collection`;
CREATE TABLE `user_collection` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `state` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKE7CA5B92146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FKE7CA5B92146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_collection
-- ----------------------------
BEGIN;
INSERT INTO `user_collection` VALUES ('0a5430ce-5d3e-4669-b965-3c88ced6149e', '2018-01-10 17:42:21', 'explanation', '2', 1, 0, '2018-01-10 17:42:21', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `user_collection` VALUES ('109e4547-0603-421b-bd98-f05c08810943', '2018-02-28 15:09:26', 'interlocution', '2', 1, 0, '2018-02-28 15:09:26', 'manager');
INSERT INTO `user_collection` VALUES ('11313c9a-b61d-47ff-a921-f785dd186512', '2018-02-28 09:48:04', 'interlocution', 'c9fbb3b8-d914-4c79-baf9-30d80099b514', 1, 0, '2018-02-28 09:48:04', 'manager');
INSERT INTO `user_collection` VALUES ('16bf6aa7-9c79-4859-b52b-2c779f6d6752', '2018-03-07 10:32:48', 'interlocution', '7d11fea4-e628-46be-bcb2-776a3c228778', 1, 0, '2018-03-07 10:32:48', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `user_collection` VALUES ('84f9609e-df02-4abc-b32d-bd2c6d455a34', '2018-02-27 16:55:00', 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', 1, 0, '2018-02-27 16:55:00', 'manager');
INSERT INTO `user_collection` VALUES ('b2409bd7-efe0-435f-bc0c-5807aa62e745', '2018-01-10 13:59:23', 'explanation', '1', 1, 0, '2018-01-10 13:59:23', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
COMMIT;

-- ----------------------------
-- Table structure for user_department_mapping
-- ----------------------------
DROP TABLE IF EXISTS `user_department_mapping`;
CREATE TABLE `user_department_mapping` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `department_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKB16509D519136585` (`department_id`) USING BTREE,
  KEY `FKB16509D5146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FKB16509D5146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKB16509D519136585` FOREIGN KEY (`department_id`) REFERENCES `sys_department` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_department_mapping
-- ----------------------------
BEGIN;
INSERT INTO `user_department_mapping` VALUES ('17137cee-57f4-48de-9faa-c8a2d4bf89be', '2018-01-10 11:15:26', 0, 0, '2018-01-10 11:15:26', '05f822d0-46a1-4f38-b26c-d00aa94dee5a', 'c511ec04-84a3-4686-a9bf-fc29f2dc315a');
INSERT INTO `user_department_mapping` VALUES ('2599ae82-d70a-4b52-a6b9-5909828567f7', '2018-01-10 17:27:34', 0, 0, '2018-01-10 17:27:34', 'f43e0233-53a4-4a8c-8466-abe60e6ef08f', '0e568a49-426a-4c0f-8730-2f3d62828c11');
INSERT INTO `user_department_mapping` VALUES ('3c744769-5519-4cb3-acec-f1bf45731e3b', '2018-01-10 06:37:07', 0, 0, '2018-01-10 06:37:07', 'f43e0233-53a4-4a8c-8466-abe60e6ef08f', '0be1af05-39c6-424a-8149-32f3d4dd6879');
INSERT INTO `user_department_mapping` VALUES ('5c6cb3ed-6a31-492c-aab7-760201922d21', '2018-01-10 17:27:34', 0, 0, '2018-01-10 17:27:34', '9ec73019-2f01-46ba-8319-ede6fd957ac2', '0e568a49-426a-4c0f-8730-2f3d62828c11');
INSERT INTO `user_department_mapping` VALUES ('83694e9b-975a-46bd-992b-3b09ba969b41', '2018-01-10 12:27:05', 0, 0, '2018-01-10 12:27:05', 'f43e0233-53a4-4a8c-8466-abe60e6ef08f', '5fdb4d70-00bf-4402-b44f-e4eff2821c0b');
INSERT INTO `user_department_mapping` VALUES ('a1e51520-55ff-4395-8430-a61297a5cd2e', '2018-01-11 19:22:47', 0, 0, '2018-01-11 19:22:47', '9ec73019-2f01-46ba-8319-ede6fd957ac2', '384ea627-d64b-4f57-89d5-c8fa083ff43c');
COMMIT;

-- ----------------------------
-- Table structure for user_integral_log
-- ----------------------------
DROP TABLE IF EXISTS `user_integral_log`;
CREATE TABLE `user_integral_log` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `state` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK154A3225146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK154A3225146ECB25` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_integral_log
-- ----------------------------
BEGIN;
INSERT INTO `user_integral_log` VALUES ('3e6e9446-f554-4ce9-bece-70bbe08039a1', '2018-02-28 10:17:14', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:14', 'manager');
INSERT INTO `user_integral_log` VALUES ('492d9b92-b4d0-4cb3-bf91-95ca74a7cb3a', '2018-02-28 10:14:43', 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', 5, 2, 0, '2018-02-28 10:14:43', 'manager');
INSERT INTO `user_integral_log` VALUES ('4be7f215-f0fa-4d94-b4a4-d1132fe8b11e', '2018-02-28 10:17:13', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:13', 'manager');
INSERT INTO `user_integral_log` VALUES ('50306334-7c65-4365-bffc-efdc94c1649e', '2018-02-28 10:28:02', 'interlocution', '15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', 5, 2, 0, '2018-02-28 10:28:02', 'manager');
INSERT INTO `user_integral_log` VALUES ('55078ecc-7853-4053-86a1-dd761f2b311c', '2018-02-28 15:11:55', 'interlocution', '7d11fea4-e628-46be-bcb2-776a3c228778', 5, 2, 0, '2018-02-28 15:11:55', 'manager');
INSERT INTO `user_integral_log` VALUES ('5ddd4dcf-28bc-492b-b0f5-5e35a852d6a3', '2018-02-28 10:27:53', 'interlocution', '15691fb0-c1b1-4fa3-8f1d-ddcfc38d883e', 5, 2, 0, '2018-02-28 10:27:53', 'manager');
INSERT INTO `user_integral_log` VALUES ('67584750-748e-4076-87e1-2032073d06a5', '2018-02-28 15:18:23', 'interlocution', '9249721b-8861-4e4e-a196-723062f67350', 5, 2, 0, '2018-02-28 15:18:23', 'manager');
INSERT INTO `user_integral_log` VALUES ('6a9f8036-3402-4ab6-b9ac-e7b86ae78809', '2018-02-28 10:22:06', 'interlocution', 'e5565093-899d-4262-8640-535bc07ae490', 5, 2, 0, '2018-02-28 10:22:06', 'manager');
INSERT INTO `user_integral_log` VALUES ('6aee1b28-f25c-4eec-87be-7d62668df8ca', '2018-02-28 09:38:27', 'interlocution', '94455f56-2e5f-459b-ac94-e589afb58ce5', 5, 2, 0, '2018-02-28 09:38:27', 'manager');
INSERT INTO `user_integral_log` VALUES ('77f26922-2636-4363-8de2-0f23689a4e2e', '2018-02-28 10:17:12', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:12', 'manager');
INSERT INTO `user_integral_log` VALUES ('79705ec5-bf6d-4f3d-a802-26e76a32125e', '2018-02-28 10:17:14', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:14', 'manager');
INSERT INTO `user_integral_log` VALUES ('7f5377ff-c274-4a15-926a-47a6499a8d8f', '2018-02-28 10:17:11', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:11', 'manager');
INSERT INTO `user_integral_log` VALUES ('92a05dac-453b-4752-ada5-85ba791485b5', '2018-02-28 10:17:16', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:16', 'manager');
INSERT INTO `user_integral_log` VALUES ('9818ae7a-7994-4572-80d8-c58a69f61aa6', '2018-02-28 10:17:15', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:15', 'manager');
INSERT INTO `user_integral_log` VALUES ('9cb906e9-1fb9-44e9-af2b-f0e607515673', '2018-02-28 09:47:31', 'interlocution', 'c9fbb3b8-d914-4c79-baf9-30d80099b514', 5, 2, 0, '2018-02-28 09:47:31', 'manager');
INSERT INTO `user_integral_log` VALUES ('a0566759-2afd-4f21-913b-5a0913af86fb', '2018-02-28 10:17:15', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:15', 'manager');
INSERT INTO `user_integral_log` VALUES ('a41574bd-ec18-43ca-9e83-b4f50fad1874', '2018-02-28 15:18:31', 'interlocution', '9249721b-8861-4e4e-a196-723062f67350', 5, 2, 0, '2018-02-28 15:18:31', 'manager');
INSERT INTO `user_integral_log` VALUES ('ad497de5-cf72-44a4-b42f-dcc54f4a0573', '2018-02-28 10:17:17', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:17', 'manager');
INSERT INTO `user_integral_log` VALUES ('b2fa94a4-5668-4822-bb08-3efb113a0a09', '2018-02-28 10:17:16', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:16', 'manager');
INSERT INTO `user_integral_log` VALUES ('cd51d296-5601-4b1d-8d49-6e21ad55ccc3', '2018-02-28 10:03:52', 'interlocution', '2f84669f-4edd-4ea1-b3f4-bd5b529d06c2', 5, 2, 0, '2018-02-28 10:03:52', 'manager');
INSERT INTO `user_integral_log` VALUES ('dd99b93e-8bc5-466e-83ca-cd9b0c765b47', '2018-02-28 10:17:15', 'interlocution', '2', 5, 2, 0, '2018-02-28 10:17:15', 'manager');
INSERT INTO `user_integral_log` VALUES ('e610034b-aa87-41f1-b808-95a50fa6b04d', '2018-02-28 09:39:44', 'interlocution', 'c9fbb3b8-d914-4c79-baf9-30d80099b514', 5, 2, 0, '2018-02-28 09:39:44', 'manager');
INSERT INTO `user_integral_log` VALUES ('f1fb53e9-dba1-4c29-9015-075a1dc7b667', '2018-02-28 10:18:30', 'interlocution', 'e5565093-899d-4262-8640-535bc07ae490', 5, 2, 0, '2018-02-28 10:18:30', 'manager');
COMMIT;

-- ----------------------------
-- Table structure for user_likes
-- ----------------------------
DROP TABLE IF EXISTS `user_likes`;
CREATE TABLE `user_likes` (
  `id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `state` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK72EB4E48146ECB25` (`user_id`) USING BTREE,
  CONSTRAINT `FK72EB4E48146ECB25` FOREIGN KEY (`user_id`) RE